How to view a trigger (Enterprise Manager)

To view 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....

See Also

Viewing a Trigger