sp_procoption [ @ProcName = ] 'procedure' -- the name of the procedure marked for auto-execution
, [ @OptionName = ] 'STARTUP' --The only value for option is startup.
, [ @OptionValue = ] 'value' -- on/off
Notes:
Startup procedures must be in the master database.
Startup procedures can't contain INPUT or OUTPUT parameters.
Execution of the stored procedures starts when the master database is recovered at startup.
Requires membership in the sysadmin fixed server role.
No comments:
Post a Comment