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
In Object Explorer, right-click a server and select Properties.
Click the Advanced node.
Under Miscellaneous, change the Scan for Startup Procs option to True or False by selecting the desired value from the drop-down list box.