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).