SQL Server Express Edition启动时如何运行存储过程?

使用系统存储过程 sp_procoption 定义要在SQL Server服务启动时执行的存储过程。

exec sp_procoption 
        @ProcName    = 'procedureName',
        @OptionName  = 'startup', 
        @OptionValue = 'true' 

USE master;
GO
-- first set the server to show advanced options
EXEC sp_configure 'show advanced option', '1';
RECONFIGURE
-- then set the scan for startup procs to 1
EXEC sp_configure 'scan for startup procs', '1';
RECONFIGURE

IF OBJECT_ID('spTest') IS NOT NULL
    DROP PROC spTest
GO
-- crate a test stored procedure
CREATE PROC spTest
AS
-- just create a sample database
EXEC('CREATE database db1')

GO
-- set it to run at sql server start-up
exec sp_procoption N'spTest', 'startup', 'on'