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]

Next Recommended Reading How to get list of all Indexes of a table in MS-SQL