Disable All Triggers in MS SQL Server Table
In MS SQL Server, run the code below to disable all TRIGGERs in a table.
ALTER TABLE {Table Name} DISABLE TRIGGER ALL
In MS SQL Server, run the code below to disable all TRIGGERs in a table.
ALTER TABLE {Table Name} DISABLE TRIGGER ALL