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 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)