SQL Server/T-SQL Tutorial/System Functions/sp makestartup
sp_makestartup configures which stored procedures will be executed when the SQL Server is started. The syntax for this stored procedure is
<source lang="sql">
sp_makestartup procedurename</source>