Hi Sanjay,

If you do:

...
RAISERROR('I want to say to my user', 11, 1)
ROLLBACK
...

The RAISERROR command will return the message back to the client with an error number of 50000.

With AERROR, catch the ODBC number.
If it's = 50000, you can show the message, because it's what you wrote.


Ricardo