You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are user-defined stored procedures. Now you have to make sure two things, first, the names of all user-defined stored procedures must contain the prefix usp_ on all instances; second, stored procedures that do not contain this prefix cannot be created by you. So what should you do to ensure this two?（）

发布日期：2020-04-10

A.You should create a policy that targets the name of the stored procedure that is evaluated on change.

B.You should create a policy that targets the name of the stored procedure that is evaluated on demand.

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 isevaluated on change.

热门试题

热门资讯

暂无相关推荐~