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

Which TCP/IP Port Does the SQL Server Run On ?

Making a MS SQL Database Offline

Getting List of All Server Databases in MS SQL

What is the Maximum Size per Database for SQL Server Express ?

What is Failover Clustering in SQL Server ?