PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the names of all user-defined stored procedures contain the prefix usp_ on all instanc

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply