November 16, 2005 at 5:15 am
Hi,
Anyone know that, how to get error description in stored procedure. I am getting the error number by @@ERROR. But i need error description.
I tryed with sysmessages table. But there are many place holders. I need the exact error message like, how the query analyser giving. if any one know abt this please help me.
Saravanan.
Saravanan V
geocities.com
November 16, 2005 at 5:50 am
There is only one place where you can get the complete errormessages, and that's at the other end of the connection calling the procedure. (eg the client)
You cannot trap complete errormessages within the procedure in many cases - for some types of errors there's simply no way to do that.
/Kenneth
November 16, 2005 at 6:31 am
hmm - I wonder if Saravanan and Gogula are working on the same project..
**ASCII stupid question, get a stupid ANSI !!!**
November 16, 2005 at 8:22 am
Maybe. I noticed the similarity as well
/Kenneth
November 16, 2005 at 10:29 pm
Thanks friends, We r not in the same project. I don't know that, who is Gogula.
I try this in some other way.
Saravanan.
Saravanan V
geocities.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply