Question
You have an Azure SQL database that contains database-level Data Definition Language (DDL) triggers, including a trigger named ddl_Audit.
You need to prevent ddl_Audit from firing during the next deployment. The trigger object must remain in place.
Which Transact-SQL statement should you use?
- A. ALTER TRIGGER
- B. ALTER DATABASE
- C. ALTER SERVER AUDIT SPECIFICATION
- D. DISABLE TRIGGER Correct
- E. ALTER DATABASE AUDIT SPECIFICATION
Explanation
DISABLE TRIGGER ddl_Audit ON DATABASE stops the trigger from firing, and the trigger still exists as an object so it can be turned back on later with ENABLE TRIGGER. ALTER TRIGGER changes the definition and actually enables the trigger. ALTER DATABASE does not control individual triggers. The two audit specification statements manage SQL Audit, not DDL triggers.
