Disable All Triggers in MS SQL Server Table

44 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

Making a Backup of MS SQL Database With Query

What is an OUTPUT Clause Inside SQL Server ?

What are the Various Limitations of the Views in SQL Server ?

What are Some Advantages of Using CTE in SQL Server ?

What is a ROLLUP Clause in SQL Server ?