Disabling a Specified Trigger in MS SQL Server

27 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

How to Restart SQL Server in Single-User Mode ?

Getting List of All Stored Procedures in Database in MS SQL

What is Deadlock in SQL Server ?

Disadvantages of Using Stored Procedures in MS SQL

Which TCP/IP Port Does the SQL Server Run On ?