How to delete a trigger (Enterprise Manager)
SQL Server 2000
To delete a trigger
- Expand a server group, and then expand a server.
- Expand Databases, expand the database in which the table containing the trigger belongs, and then click Tables.
- In the details pane, right-click the table on which the trigger exists, point to All Tasks, and then click Manage Triggers.
- In Name, click the name of the trigger to delete.
- Click Delete.
- Confirm the deletion.