Database Triggers Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Database Triggers Editor lets you enable or disable a database trigger and modify the body of the generated CREATE TRIGGER statement.

To edit a database trigger:

  1. Open an editor on the database trigger. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Select the Enabled check box to enable the database trigger or deselect it to disable the trigger. In addition to the name and creation date details, this tab also lets you view the Trigger Timing and Encrypted property settings you chose when creating the trigger. For details on these properties, see Database Triggers (SQL Server) - Properties.


Lets you modify the CREATE TRIGGER statement.


Lists referring and referenced objects potentially impacted by the change. For details, see Working with Object Dependencies.

Trigger Events

Lets you view the DDL events you selected to fire this trigger.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.