DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ40

VerifiedSecure, optimize, and deploy database solutions

You have an Azure SQL database that contains database-level Data Definition Language (DDL) triggers, including one named ddl_Audit.

You need to stop ddl_Audit from firing during the next deployment while keeping the trigger object in place.

Which Transact-SQL statement should you use?

Explanation

DISABLE TRIGGER prevents a database-scoped DDL trigger from firing without dropping the trigger object. For this trigger, the applicable form is DISABLE TRIGGER ddl_Audit ON DATABASE.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!