Reports a listing of all auto-start stored procedures.
sp_helpstartup
Executing sp_helprotect reports a list of all stored procedures marked for auto execution (to be run when the server is started).
This example reports information about all auto execution stored procedures.
sp_helpstartup
Execute permission defaults to the public group. However, only a system administrator can make an auto execution stored procedure.
master.dbo.sysobjects
CREATE PROCEDURE | sp_unmakestartup |
sp_makestartup |