How to modify a trigger (Enterprise Manager)

To modify a trigger

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table containing the trigger belongs, and then click Tables.
3. In the details pane, right-click the table on which the trigger exists, point to All Tasks, and then click Manage Triggers....
4. In Name, select the name of the trigger.
5. Change the text of the trigger in the Text field as necessary. Press CTRL+TAB to indent the text of a SQL Server Enterprise Manager trigger.
6. To check the syntax of the trigger, click Check Syntax.

See Also

Modifying and Renaming a Trigger