sql server 创建启动存储过程

创建一个启动存储过程， 每当sql server 实例 启动时执行。除此之外，和其他存储过程类似

use master
go

-- open 'show advanced options'
sp_configure 'show advanced options', 1;
GO
Reconfigure;
go

-- scan for startup procs
sp_configure 'scan for startup procs', 1;
GO
Reconfigure;
go

-- restart sql server instance manaully

-- create table to log sql server start time.
create table master.dbo.SQLStartupLog(StartTime datetime);
GO

-- create proc to insert slq server start time in the table
create proc dbo.InsertSQLStartupLog
as
Insert into master.dbo.SQLStartupLog
select getdate();
go

-- enable the InsertSQLStartupLog proc to be the startup proc
sp_procoption @ProcName='master.dbo.InsertSQLStartupLog',@OptionName='startup',@OptionValue=1;
go

-- restart sql server instance manaully to see the records.
select * from master.dbo.SQLStartupLog
go

-- finally recover below t-sql.
sp_procoption @ProcName='master.dbo.InsertSQLStartupLog',@OptionName='startup',@OptionValue=0;
drop table master.dbo.SQLStartupLog;
drop proc dbo.InsertSQLStartupLog;
go