T-SQL Tutorial

T-SQL Disable Trigger


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