You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do?()
- AImplement a stored procedure that writes data about schema changes to a log table.
- BImplement DDL AFTER triggers that write user and schema information to a log table.
- CImplement a DML INSTEAD OF trigger that writes data about schema changes to a log table.
- DImplement a DML AFTER trigger that writes data about schema changes to a log table.