You maintain several SQL Server 2008 instances. You need to ensure that the names of all
user-defined stored procedures contain the prefix usp_ on all instances.
You also need to ensure that you cannot create stored procedures that do not contain this
prefix.
What should you do?
A.
Create a policy that targets the name of the stored procedure that is evaluated on change.
B.
Create a policy that targets the name of the stored procedure that is evaluated on
demand.
C.
Create a condition that targets the name of stored procedure that is evaluated on
demand.
D.
Create a condition that targets the name of the stored procedure that is evaluated on
change.