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

Using MS SQL COUNT

What is the Difference Between VARCHAR and VARCHAR(MAX) Datatypes ...

What are OFFLINE Datafiles with SQL Server ?

General Information List of All Allowed Databases in MS SQL Serve ...

What is Resource Governor in SQL Server ?