You administer a SQL Server 2008 infrastructure. Your company wants to enforce naming
standards for the database objects. You need to design a solution to enforce naming
standards by using the minimum amount of administrative and programming efforts. What
should you do?
A.
Use event notifications to handle the DDL events.
B.
Create Policy-Based Management policies, and then distribute the policies by using a
configuration server.
C.
Create DDL triggers for one of the instances, and then use SQL Server Management
Objects (SMO) to script the definition of the DDL triggers. Run the script by using Microsoft
Windows PowerShell on all instances.
D.
Create DDL triggers for one of the instances, and then use Microsoft SQL Server
Management Studio (SSMS) to script the definition of the DDL triggers. Run the script on all
instances by using the registered servers node from SSMS.