Collections:
"DISABLE TRIGGER" - Disabling Triggers in SQL Server
How To Disable Triggers using "DISABLE TRIGGER" in SQL Server?
✍: FYIcenter.com
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 Triggers for INSERT Statements Only in SQL Server
⇐ sys.sql_modules - Getting Trigger Definitions Back in SQL Server
2016-10-24, 2014🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...