|
|
| |
How do I mark the stored procedure to automatic execution?
Answer:
You can use the sp_procoption system stored procedure to mark the stored
procedure to automatic execution when the SQL Server will start.
Note. Only objects in the master database owned by dbo can have the startup
setting changed and this option is restricted to objects that have no
parameters.
This is the example to set the startup option for the indRebuild stored
procedure in the master database:
USE master
EXEC sp_procoption 'indRebuild', 'startup', 'true'
|
See SQL Server Books Online for more details about the sp_procoption
system stored procedure.
|
|
|
