sp_unmakestartup System Stored Procedure

Discontinues auto execution of the stored procedure.

Syntax

sp_unmakestartup procedure_name

where

procedure_name

Specifies the name of the procedure that should no longer automatically execute when the server is started.

Example

This example unmarks the update_all_stats procedure from being an auto execution procedure.

sp_unmakestartup update_all_stats

Permission

Only the system administrator can use this procedure.

Tables Used

master.dbo.sysobjects

See Also