How to delete a trigger (Enterprise Manager)

How to Install SQL Server 2000

How To

How to delete a trigger (Enterprise Manager)

To delete a trigger

  1. Expand a server group, and 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, click the name of the trigger to delete.

  5. Click Delete.

  6. Confirm the deletion.

See Also

Deleting a Trigger