January 4, 2006 at 1:17 pm
I have a developer that has a raiseerror condition in his trigger, followed by a rollback. The raiserror is as follows...raiseerror('text message',11,1). He has two conditions that will produce this error...1) insert function which produces a duplicate and 2) using the copy function which produce a duplicate. On the insert function the raiserror popup window appears followed by a rollback. On the copy function the raiserror popup window does not appears, but it does get rollback...rows was not inserted.
Any ideas?
January 4, 2006 at 1:41 pm
What does the "copy function" do ? It's possible that it's generating an error with a high enough severity that it can't be trapped by checking @@error, therefore the entire batch gets rolled back before the error handler can get to execute the RaisError().
January 4, 2006 at 1:59 pm
The developer can run the same copy function on our development box and gets the popup. I don't know of any differences between our development environment and our production.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply