Disable Trigger TSQL Tutorial

Disable Trigger Syntax

ALTER TABLE table_name DISABLE TRIGGER ALL;
DISABLE Trigger master.trigger_name ON master.table_name ;
DISABLE Trigger ALL ON ALL SERVER;


Disable Trigger Example


ALTER TABLE Customers DISABLE TRIGGER ALL;
DISABLE Trigger system.Customers_Op ON system.Customers ;
DISABLE Trigger ALL ON ALL SERVER;

See also:
SQL Server