mark the stored procedure to automatic execution [ All Languages » SQL Server »  Server Operations] Total Hit ( 2762) Rate this article:     Poor     Excellent   Submit Your Question/Comment about this article Rating

You can use the sp_procoption system stored procedure to mark the stored procedure to automatic execution when the SQL Server will start. Note. Only objects in the master database owned by dbo can have the startup setting changed and this option is restricted to objects that have no parameters. This is the example to set the startup option for the indRebuild stored procedure in the master database: Click here to copy the following block USE master EXEC sp_procoption 'indRebuild', 'startup', 'true' See SQL Server Books Online for more details about the sp_procoption system stored procedure.

Related Article(s)

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)
	Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )