_____________ sets procedure options in SQL Server.
A. sp_procoption
B. sp_dropmessage
C. sp_altermessage
D. sp_executesql
Answer:A
_____________ sets procedure options in SQL Server.
A. sp_procoption B. sp_dropmessage C. sp_altermessage D. sp_executesql
Explanation:sp_procoption sets exactly one option to configure a stored procedure for auto execution when SQL Server starts up.