Triggers Editor (SQL Server)

Go Up to Microsoft SQL Server Object Editors

The Triggers Editor lets you enable and disable a trigger, view and modify the CREATE TRIGGER statement that will implement changes, and manage dependencies.

To edit a trigger

1. Open an editor on the 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
Properties	Lets you set the Enabled property. It also lets you view the Trigger Timing (AFTER, INSTEAD OF), Fire On Insert, Fire On Update, Fire On Delete, and Encrypted properties.
Definition	Lets you modify the CREATE TRIGGER body for a trigger. To modify a trigger, edit the text of the trigger body in the Trigger Text area. The existing trigger is automatically dropped and then recreated.
Dependencies	For details on using this tab, see Working with Object Dependencies.

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