Disabling a Specified Trigger in MS SQL Server

194 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

Creating a View in MS SQL

Getting List of All Views in MS SQL Database

What is the Use of DBCC Commands in SQL Server ?

What is Central Management in SQL Server ?

What is the Merge Statement in SQL Server ?