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