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
sp_makestartup procedurename
sp_makestartup procedurename