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

What is Data Collector in SQL Server ?

Getting List of System Hard Disks with Free Space in MS SQL Serve ...

What is Central Management in SQL Server ?

Creating a View in MS SQL

What are Indexed Views inside SQL Server ?