"DISABLE TRIGGER" - Disabling Triggers in SQL Server

Q

How To Disable Triggers using "DISABLE TRIGGER" in SQL Server?

✍: FYIcenter.com

A

If want to stop the execution of an existing trigger temporarily, you can use the "DISABLE TRIGGER" statement to disable it. The disabled trigger will be kept in the database.

If you want to resume the execution of a disabled trigger, you can use the "ENABLE TRIGGER" statement to enable it.

The tutorial exercise below shows you how to disable and enable triggers:

USE FyiCenterData
GO

-- disabling a trigger
DISABLE TRIGGER dml_message ON fyi_users;
GO

INSERT INTO fyi_users (name) VALUES ('Jack Gate');
GO
(1 row(s) affected)

-- enabling a trigger
ENABLE TRIGGER dml_message ON fyi_users;
GO

INSERT INTO fyi_users (name) VALUES ('Roy Bush');
GO
Time: Jul  1 2007 
Records are inserted, updated, or deleted in fyi_users
(1 row(s) affected)

 

Creating and Managing Triggers in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-24, 637👍, 0💬