Disable All Triggers in MS SQL Server Table

46 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 DB Mirroring and Log Shipping in S ...

What is Resource Governor in SQL Server ?

What is NOLOCK Hint in SQL Server ?

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

Getting List of All Server Databases in MS SQL