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


You May Interest

What is Utility Control Point (UCP) in SQL Server ?

What is Log Shipping in SQL Server ?

What is the XML Datatype in SQL Server ?

Generating Random Letters in MS SQL

What is Auditing Inside SQL Server ?