Aspnet_regsql.exe command line usage Summary

The aspnet_regsql.exe command line has the following options:
Only a few commonly used command items are selected below. For details, refer to here
1. SQL connection options

  - E. Use the Windows creden; of the current logon user for authentication;
  - S specifies the name of the computer on which SQL server is running and the database will be installed or installed;
  - U is the ID of the SQL Server user to log on. This option also requires a password ( - P) option. If you want to use Windows creden ( - E) for identity authentication, this option is not required;
  - P The SQL server password to be used for logon. This option also requires the use of user ID ( - U) option. If you want to use Windows creden ( - E) for authentication, this option is not required
  - C specifies the connection string of the computer on which the SQL server is running and the database is installed or installed. If you only specify ( - S) and login ( - U and - P, or - E) information, this option is not required

2. ApplicationProgramService options

  - A adds support for one or more ASP. NET application services. You can specify a Service Identifier at the same time or separately. The following identifiers are used for ASP. NET application services.
All -- All services, including common tables shared by services and
M -- Member qualifications
R -- Role Manager
P -- Configuration File
C -- Customize Web parts

Of course, the corresponding-R is to remove these application services.
3. SQL dependency cache Dependencies

- Ed enables the database for SQL cache Dependencies
- Dd disables the database for SQL cache Dependencies
- Et enables tables for SQL cache dependencies. The parameter string must also contain - T Option
- DT indicates that the SQL cache dependency is disabled. The parameter string must also contain - T Option
- T specifies the name of the table to be enabled or disabled for use with the SQL cache dependency. This option must be - ET or - Use DT options together

The following is an example:
1. provide the program service for creating membership for the created database named nbadata (if the input database name does not exist or is not written, a new database or a default aspnetdb database will be created). Here, log on to the SQL Server for authentication and use the Visual Studio 2008 command prompt tool:

code highlighting produced by actipro codehighlighter (freeware)
http://www.CodeHighlighter.com/

--> aspnet_regsql.exe-s localhost-U sa-P @ ssw0rd-D nbadata-A m

2. Enable cache dependency for a table player in the database nbadata. If cache dependency is not enabled for the database, enter the command-ed to enable cache dependency for the database: Aspnet_regsql.exe-s localhost-U sa-P @ ssw0rd-D nbadata-ed-et-T playerAspnet_regsql.exe-SLocalhost-E-ssadd-sstype c-dYourdbname

 

After the cache dependency is successfully added, a table named aspnet_sqlcachetablesforchangenotification is added to the database, and a row of records exists.