You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008.
You are the administrator of the company database. Now you are in charge of a SQL Server
2008 instance. According to the company requirement, the names of all user-defined stored
procedures must contain the prefix usp_on all instances. Besides this, you must make sure
that stored procedures that do not contain this prefix cannot be created by you. What should
you do?
A.
A policy should be created. The policy targets the name of the stored procedure that is
evaluated on demand.
B.
A policy should be created. The policy targets the name of the stored procedure that is
evaluated on change.
C.
A condition should be created. The condition targets the name of the stored procedure
that is evaluated on change
D.
A condition should be created. The condition targets the name of stored procedure that is
evaluated on demand.