CODE EXAMPLE FOR SQL

disable trigger sql server

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