You are the administrator of your company network. And you’re in charge of a SQL Server 2008 infrastructure. Now you are assigned a task to enforce naming standards for the database objects, so you have to design a solution to achieve this while using as little programming and administrative efforts as possible. So what should you do?
A.
You should use event notifications to handle the DDL events.
B.
You should create Policy-Based Management policies, and then distribute the policies by using a configuration server.
C.
You should 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 PowerShell on all instances.
D.
You should 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.