SQL

sql disable trigger

//use the following commands 
//disable
ALTER TABLE table_name DISABLE TRIGGER tr_name
//enable
ALTER TABLE table_name ENABLE TRIGGER tr_name

disable trigger sql server

DISABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL }  
ON { object_name | DATABASE | ALL SERVER } [ ; ]
-- DISABLE Trigger ALL ON ALL SERVER;