SALES: 1-800-867-1380


This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

This topic is not maintained. For the current version, see ENABLE TRIGGER.

Enables a data manipulation language (DML) trigger, data definition language (DDL) trigger, or logon trigger.

Syntax Conventions (Azure SQL Database)

ENABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL }
ON { object_name | DATABASE } [ ; ]

This syntax diagram demonstrates the supported arguments and options in Microsoft Microsoft Azure SQL Database.

Microsoft Azure SQL Database does not support the ALL SERVER argument with the ENABLE TRIGGER statement.

For more information about the arguments and the ENABLE TRIGGER statement, see ENABLE TRIGGER in SQL Server Books Online.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft