Export (0) Print
Expand All
Expand Minimize

How to: Configure the scan for startup procs Option (SQL Server Management Studio)

Use the scan for startup procs option to scan for automatic execution of stored procedures at Microsoft SQL Server startup time. If this option is set to 1, SQL Server scans for and runs all automatically run stored procedures defined on the server. The default value for scan for startup procs is 0 (do not scan).

To configure the scan for startup procs option

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Advanced node.

  3. Under Miscellaneous, change the Scan for Startup Procs option to True or False by selecting the desired value from the drop-down list box.

Community Additions

ADD
Show:
© 2014 Microsoft