Wednesday, March 7, 2012

Returning the error message in a stored proc

Hi everyone!
I know how to return an error id in a stored proc with the @.@.ERROR
variable but is it possible to also return the corresponding error
message?
Thanks!Hi!
SQL 2000 it is, and I tried to get message from sysmessages and I
realised it doesn't substitute the varaibles as you suggest.
So, is there any way to get the message with substitued values?
Thanks!|||Allright, thanks a lot!

No comments:

Post a Comment