Enable and Disable Triggers

----- 1: Disable All Triggers
ALTER TABLE dbo.TableName
DISABLE TRIGGER ALL

----- 2: Enable All Triggers
ALTER TABLE dbo.TableName
ENABLE TRIGGER ALL

----- 3: Disable One Trigger
ALTER TABLE dbo.TableName
DISABLE TRIGGER TriggerName

----- 4: Enable One Trigger
ALTER TABLE dbo.TableName
ENABLE TRIGGER TriggerName