You are the administrator of your company network. You are in charge of a SQL Server 2008 instance.
You have to make sure that the names of all user-defined stored procedures contain the prefix usp_ on all instances. Besides this, you have to make sure that you cannot create stored procedures that do not contain this prefix. So what should you do?
A.
You should create a policy that targets the name of the stored procedure that is evaluated on demand.
B.
You should create a policy that targets the name of the stored procedure that is evaluated on change.
C.
You should create a condition that targets the name of stored procedure that is evaluated on demand.
D.
You should create a condition that targets the name of the stored procedure that is evaluated on change.