Web Development

General discussion


How to drop SQL trigger

By agofman ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by nikki96 In reply to How to drop SQL trigger

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.

Collapse -

by agofman In reply to

Poster rated this answer.

Collapse -

by saravanakumar77 In reply to How to drop SQL trigger

try with create or replace trigger <trig name> syntax.

Collapse -

by xpherion In reply to How to drop SQL trigger

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

Related Discussions

Related Forums