This is actually quite simple. There is 'startup' option that you can set to the procedure.
There are a few limitations though:
- sp must reside in the [master] database
- it's owner must be dbo
- it mustn't have any input or output parameters
Note that each stored procedure run at start up takes up one worker thread until finished. So if you want to run multiple sps at runtime and parallelism doesn't matter create one sp that executes all others.
USE master;-- first set the server to show advanced optionsEXEC sp_configure 'show advanced option', '1';-- then set the scan for startup procs to 1EXEC sp_configure 'scan for startup procs', '1';-- crate a test stored procedure-- just create a sample databaseEXEC('CREATE database db1')-- set it to run at sql server start-upexec sp_procoption N'spTest', 'startup', 'on'