SQL Server - "DISABLE TRIGGER" - Disabling Triggers in SQL Server

"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, 777👍, 0💬

sys.sql_modules - Getting Trigger Definitions Back in SQL Server
How To Get the Definition of a Trigger Back in SQL Server? If you want get the definition of an existing trigger back from the SQL Server, you can use the catalog view called sys.sql_modules, which stores definitions of views, stored procedures, and triggers. The sys.sql_modules holds trigger defini... 2016-10-24, 1093👍, 0💬

"DISABLE TRIGGER" - Disabling Triggers in SQL Server
How To Disable Triggers using "DISABLE TRIGGER" in SQL Server? 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, yo... 2016-10-24, 778👍, 0💬

Creating Triggers for INSERT Statements Only in SQL Server
How To Create a Trigger for INSERT Only in SQL Server? The trigger, dml_message, provided in previous tutorials was defined to handle all 3 types of DML statements, INSERT, UPDATE, and DELETE. If you do not want the trigger to handle all 3 types of DML statements, you can list only 1 or 2 of the sta... 2016-10-24, 719👍, 0💬

"DROP TRIGGER" - Deleting Existing Triggers in SQL Server
How To Delete Existing Triggers using "DROP TRIGGER" in SQL Server? If you don't want to use a trigger any more, you should delete it from the database by using the "DROP TRIGGER" statement as shown in tutorial example: USE FyiCenterData; GO DROP TRIGGER new_user; GO SELECT * FROM sys.triggers GO na... 2016-10-24, 632👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.