Disable All Triggers in MS SQL Server Table

184 Reads Ms Sql

In MS SQL Server, run the code below to disable all TRIGGERs in a table.

ALTER TABLE {Table Name} DISABLE TRIGGER ALL
Ms Sql

You May Interest

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...

What are the System Data Collection Sets Predefined Inside SQL Se ...

What is Failover Clustering in SQL Server ?

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

Finding Session Id in MS SQL User's Current Process