Disabling a Specified Trigger in MS SQL Server

203 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

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

Using MS SQL TOP

What are the System Data Collection Sets Predefined Inside SQL Se ...

What is the Difference Between Update Lock and Exclusive Lock in ...

Creating a View in MS SQL