How To Disable Triggers using "DISABLE TRIGGER"?
Submitted by: AdministratorIf 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 GlobalGuideLineDatabase
GO
-- disabling a trigger
DISABLE TRIGGER dml_message ON ggl_users;
GO
INSERT INTO ggl_users (name) VALUES ('MHI Gate');
GO
(1 row(s) affected)
-- enabling a trigger
ENABLE TRIGGER dml_message ON ggl_users;
GO
INSERT INTO ggl_users (name) VALUES ('Roy MHI');
GO
Time: Jul 1 2007
Records are inserted, updated, or deleted in ggl_users
(1 row(s) affected)
Submitted by: Administrator
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 GlobalGuideLineDatabase
GO
-- disabling a trigger
DISABLE TRIGGER dml_message ON ggl_users;
GO
INSERT INTO ggl_users (name) VALUES ('MHI Gate');
GO
(1 row(s) affected)
-- enabling a trigger
ENABLE TRIGGER dml_message ON ggl_users;
GO
INSERT INTO ggl_users (name) VALUES ('Roy MHI');
GO
Time: Jul 1 2007
Records are inserted, updated, or deleted in ggl_users
(1 row(s) affected)
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
☺ | How To Execute the Cursor Queries with "OPEN" Statements? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | How To Convert a Numeric Expression from One Data Type to Another? |
☺ | How To Create a Large Table with Random Data for Index Testing in MS SQL Server? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |