Disabling a Specified Trigger in MS SQL Server

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

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


You May Interest

Disabling All Constants in a Table in MS SQL

What is Log Shipping in SQL Server ?

Getting List of All Server Databases in MS SQL

What are the Authentication Modes in SQL Server ?

What is a Filestream in SQL Server ?