Web Development

Ask something
Discussion Locked

How to drop SQL trigger

0 helpful
4 replies

by agofman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I issue "drop trigger abc" I receive:
"Server: Msg 3701, Level 11, State 5, Line 1
Cannot drop the trigger UTR_Duplicate_REQ', because it does not exist in the system catalog."

When I issue "CREATE TRIGGER UTR_Duplicate_REQ
ON lawprod.REQHEADER FOR INSERT" I receive:
"Server: Msg 2714, Level 16, State 5, Procedure UTR_Duplicate_REQ, Line 65535
There is already an object named 'UTR_Duplicate_REQ' in the database."

What's wrong and how to drop/create a trigger?

4 replies

by nikki96

There is already an OBJECT with that name. Not necessarily a trigger. Could be a constraint or a view or a table or a stored procedure or whatever.

Name the trigger something else or go looking around the DB for the object with that name to drop it before creating the trigger.

by xpherion

open sql enterprise manager and right click on the table properites and then manager trigger and delete trigger.

This discussion is closed to new replies.