You are a professional level SQL Sever 2008 Database Administrator. Your company wants
to enforce naming standards for the database objects. A solution should be designed by you
to enforce naming standards, and the least amount of administrative and programming
efforts should be utilized. Which action should you perform?
A.
DDL triggers should be created for one of the instances, and then Microsoft SQL Server
Management Studio (SSMS) should be utilized to script the definition of the DDL triggers. At
last, the script should be run on all instances by utilizing the registered server??s node from
SSMS.
B.
DDL triggers should be created for one of the instances, and then SQL Server
Management Objects (SMO) should be utilized to script the definition of the DDL triggers. At
last, the script should be run by utilizing Microsoft Windows PowerShell on all instances.
C.
Policy-Based Management policies should be created, and then the policies should be
distributed by utilizing a configuration server.
D.
Event notifications should be utilized to handle the DDL events.