You are a database administrator for AIOTestKing.com. Developers need access to create, alter, and drop tables in your SQL Server 2005 database. A list of production tables is maintained in a table named Valid_Production_Tables in the database. You need to be able to automatically roll back any commands that drop or alter current production tables.
You need to do this while minimizing the processor resources being used. What should you do?
A.
Use a DML trigger to execute the FOR UPDATE, DELETE command on the Valid_Production_Tables table.
B.
Use Event Notification to execute the FOR DDL_TABLE_EVENTS command.
C.
Use Event Notification to execute the FOR ALTER_TABLE, DROP_TABLE command.
D.
Use a DDL trigger to execute the FOR DROP_TABLE, ALTER_TABLE command.