Disabling a Specified Trigger in MS SQL Server

44 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 Auditing Inside SQL Server ?

How to Optimize Stored Procedure in SQL Server ?

Changing MS SQL Database Name with Query

What is SQL Profiler ?

What is CHECKPOINT Process in the SQL Server ?