I answered correctly but I wonder if the answer with "The process works normally but produces an error message" could be implemented? Something like in the trigger text:
Begin Transaction
<update statements>
RAISEERROR (with severety level 1 - informational)
Commit Transaction
I also wonder if the trigger type is "Instead Of" could we make the trigger insert rows but produce the message?
Yelena
I guess it is more a friendly critique of the format of the question. It was a little rough to read through, and having psuedo code would have helped me understand the question more easily. I did not have the answers available at the time as I was reading the question from the email.
