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?