SQL Server/T-SQL Tutorial/System Functions/sp procoption
Executing Stored Procedures Automatically at SQL Server Startup
<source lang="sql">
3> 4> USE MASTER 5> GO Changed database context to "master". 1> 2> CREATE TABLE dbo.SQLStartupLog 3> (SQLStartupLogID int IDENTITY(1,1) NOT NULL PRIMARY KEY, 4> StartupDateTime datetime NOT NULL) 5> GO 1> 2> CREATE PROCEDURE dbo.usp_INS_TrackSQLStartups 3> AS 4> INSERT dbo.SQLStartupLog 5> (StartupDateTime) 6> VALUES (GETDATE()) 7> GO 1> 2> EXEC sp_procoption @ProcName = "usp_INS_TrackSQLStartups", 3> @OptionName = "startup", 4> @OptionValue = "true" 5> 6> GO 1> 2> EXEC sp_procoption @ProcName = "usp_INS_TrackSQLStartups", 3> @OptionName = "startup", 4> @OptionValue = "false" 5> GO 1> 2> drop table dbo.SQLStartupLog 3> GO 1> drop procedure dbo.usp_INS_TrackSQLStartups 2> GO 1></source>