Disabling a Specified Trigger in MS SQL Server

209 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

What is a ROLLUP Clause in SQL Server ?

What is Blocking in SQL Server ?

What is FILLFACTOR in SQL Server ?

How is Deadlock Different From a Blocking Situation in SQL Server ...

What is the Merge Statement in SQL Server ?