How to Disable / Enable triggers in MS-SQL


Two easiest command syntacx to disable /enable existing triggers on table are as below-

To Disable-

 ALTER TABLE    [mySchemaName].[myTableName]  DISABLE TRIGGER myTriggerName

; DISABLE TRIGGER  myTriggerName ON [mySchemaName].[myTableName]



To Enable-

 ALTER TABLE    [mySchemaName].[myTableName]  ENABLE TRIGGER myTriggerName

; ENABLE TRIGGER  myTriggerName ON [mySchemaName].[myTableName]