How to create a trigger (Enterprise Manager)

How to create a trigger (Enterprise Manager)

To create a trigger

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, expand the database in which the table to contain the trigger belongs, and then click Tables.
   
   
3. In the details pane, right-click the table on which the trigger will be created, point to All Tasks, and then click Manage Triggers.
   
   
4. In Name, click <new>.
   
   
5. In the Text box, enter the text of the trigger. Use CTRL-TAB to indent the text of a trigger.
   
   
6. To check the syntax, click Check Syntax.

See Also

Creating a Trigger