SQL Server/T-SQL Tutorial/System Functions/sp unmakestartup

sp_unmakestartup disables the auto-execution of the stored procedures specified.

   <source lang="sql">

The syntax for this stored procedure is sp_unmakestartup procedurename</source>