sys.sp_procoption

general

#stored-procedure

Description

Sets or clears a stored procedure for automatic execution. A stored procedure that is set to automatic execution runs every time an instance of SQL Server is started.

Syntax

sys.sp_procoption
[ @
P roc
N ame = ]
N
'ProcName'
, [ @
O ption
N ame = ]
'OptionName'
, [ @
O ption
V alue = ]
'OptionValue'
[ ; ]