Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
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).

  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft