Automatically execute stored procedures when you move SQL Server

server| Stored Procedures | executing

How do I execute a stored procedure when I start SQL Server?

Create the stored procedure in the master database, and then locate the stored procedure in Enterprise Manager-right--Properties--check "execute whenever SQL Server starts".

-or after the stored procedure is created in master, the execution statement is set to start automatically

Use master

EXEC sp_procoption ' stored procedure name ', ' Startup ', ' on '
---------------------------------------------------------------

Automatic execution of stored procedures

SQL Server can automatically execute one or more stored procedures when it starts. These stored procedures must be created by the system administrator and executed as background procedures under the sysadmin fixed server role. These procedures cannot have any input parameters.

There is no limit to the number of startup procedures, but be aware that each startup process consumes one connection at execution time. If you must execute multiple procedures at startup, but do not need to execute in parallel, you can specify a procedure to use as a startup procedure to call another procedure. This takes up only one connection.

When the last database is restored at startup, the stored procedure is started. To skip execution of these stored procedures, specify the startup parameters as trace flag 4022. If you start SQL Server with the lowest configuration (with the-f tag), the startup stored procedure is not executed. For more information, see Trace Flags.

To create a startup stored procedure, you must be logged on as a member of the sysadmin fixed server role and create a stored procedure in the master database.

Use sp_procoption to:

Specify an existing stored procedure as the startup process.

The blocking process executes when SQL Server starts.