Disabling a Specified Trigger in MS SQL Server

36 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

Getting List of All Stored Procedures in Database in MS SQL

Deleting Table With Query in MS SQL

MS SQL Finding Which Tables a Column Name is In

What is Partial Cache Mode in SSIS ?

What is the Filtered Index in SQL Server ?