Disabling a Specified Trigger in MS SQL Server

31 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 are Table Valued Parameters ?

What is Utility Control Point (UCP) in SQL Server ?

Listing Metadata of MS SQL Server Internal Tables

What are Replication and Database Mirroring in SQL Server ?

What is Central Management in SQL Server ?