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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
