How to run a stored procedure when SQL Server Express Edition starts?

Question

How is it possible to run a stored procedure when SQL Server Express Edition starts?

Answer 1

Use the system stored procedure sp_procoption to define the stored procedure you wish to be executed at SQL Server Service startup.

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

Answer 2

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'