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