Disabling a Specified Trigger in MS SQL Server

213 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 is an OUTPUT Clause Inside SQL Server ?

Disabling All Constants in a Table in MS SQL

MS SQL Getting List of All Column Names of a Table

How to Optimize Stored Procedure in SQL Server ?

What is a Linked Server in SQL Server ?