Microsoft® SQL Server 2012 Unleashed

scan for startup procs

Type: Advanced

Default value: 0

When the scan for startup procs option is set to 1, SQL Server scans for and executes all automatically executed stored procedures on the server on startup. To set a stored procedure to become automatically executed, you use the sp_procoption system stored procedure. Typically, a stored procedure is executed at startup time when you want to have certain processing occur that creates the proper working environment for all subsequent database processing on the server. You also can execute at startup when you want to make sure that certain stored procedures’ execution plans (with proper optimizer decisions) are already in the procedure cache before anyone else requests their execution.

The following ...