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.
正确答案:B
答案解析:有
微信扫一扫手机做题