October 27, 2004 at 6:33 am
I have an INSERT/UPDATE trigger on a table, and every time I run an update statement on the table that fires the trigger I receive the following warning in Query Analyzer:
"Please do not drop this trigger. Contact DBA for advise."
I'm not trying to drop the trigger, so I have no idea where the warning comes from. Anyone who knows what causes this warning and what to do about it?
Regards,
Jorg Jansen
Jorg Jansen
Manager Database Development
Infostradasports.com
Nieuwegein
The Netherlands
October 27, 2004 at 7:03 am
run sp_helptext triggername, and search for the message syntax. Sure the owner of the trigger inserted in the code that message to run every time the trigger fires.
October 27, 2004 at 7:58 am
I think recosta is right. That is not a sql server error so must have been put in if certain condition is true....Looks like its ignoring the condition and displaying everytime.
Tajammal Butt
October 28, 2004 at 2:14 am
Yes, I agree this a custom message, and not the SQL Engine.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply