Disabling a Specified Trigger in MS SQL Server

187 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

Disadvantages of Using Stored Procedures in MS SQL

What is SQL Server Agent ?

What are the Limitations of Indexed Views in SQL Server ?

How to Show Line Numbers in MS SQL Server ?

What is Service Broker in SQL Server ?