sp_helpstartup System Stored Procedure

Reports a listing of all auto-start stored procedures.

Syntax

sp_helpstartup

Remarks

Executing sp_helprotect reports a list of all stored procedures marked for auto execution (to be run when the server is started).

Example

This example reports information about all auto execution stored procedures.

sp_helpstartup

Permission

Execute permission defaults to the public group. However, only a system administrator can make an auto execution stored procedure.

Table Used

master.dbo.sysobjects

See Also

CREATE PROCEDURE sp_unmakestartup
sp_makestartup