how to get error description in stored procedure

  • 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.


    Kindest Regards,

    Saravanan V
    geocities.com

  • 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

  • hmm - I wonder if Saravanan and Gogula are working on the same project..

    error description







    **ASCII stupid question, get a stupid ANSI !!!**

  • Maybe. I noticed the similarity as well

    /Kenneth

  • 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.


    Kindest Regards,

    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