SQL Server - Setting the Scan For Startup Procs server configuration option to 0

This option enables the SQL Server to scan for and automatically run all the stored procedures that are set to execute on service startup

Run the following T-SQL command on the IRC and the CM database:

EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE;
EXECUTE sp_configure 'Scan for startup procs', 0;
RECONFIGURE;
GO
EXECUTE sp_configure 'show advanced options', 0;
RECONFIGURE;