Enable Trigger TSQL Tutorial

Enable Trigger Syntax

ENABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n_trigger_name ] | ALL }
ON { table_name | DATABASE | ALL SERVER } [ ; ]


Enable Trigger Example 1

ALTER TABLE Customers ENABLE TRIGGER ALL;

Enable Trigger Example 2

ENABLE Trigger master.Customers_Op ON master.Customers ;

See also:
SQL Server