ASP.NET SQL Server Registration Tool – Aspnet_regsql.exe
This tool is a part of Microsoft .Net framework and like other tools this tool is also located in [drive:]%windir%Microsoft.NETFrameworkversion folder on your Web server.The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to add or remove options from an existing database. You can run Aspnet_regsql.exe without any command-line arguments to run a wizard that will walk you through specifying connection information for your SQL Server installation, and installing or removing the database elements for the membership, role management, profile, Web Parts personalization, and health monitoring features. You can also run Aspnet_regsql.exe as a command-line tool to specify database elements for individual features to add or remove, using the options listed in the table below.
See the Reference URL for Detail