Disabling a Specified Trigger in MS SQL Server

45 Reads Ms Sql

To disable a TRIGGER specified in MS SQL Server, the following procedure is followed.

ALTER TABLE {Table Name} DISABLE TRIGGER {Trigger Name}
Ms Sql

You May Interest

Using MS SQL DISTINCT

Getting the Id of MS SQL Server Last Entered Record

What is a ROLLUP Clause in SQL Server ?

What is the Difference Between Clustered and a Non-clustered Inde ...

What are Sparse Columns in SQL Server ?