Post reply

Capture error mesgs

  • July 12, 2006 at 7:40 am

    #169107

    Hi

    When I raise errors in my SP how can I capture them in a sql table

  • July 12, 2006 at 1:01 pm

    #648799

    You can record them if they don't abort a transaction or terminate the connection, by changing the sp to capture the value of @@error immediately after each statement in the sp, and insert it into your table if it's <> 0. You can't suppress the errors though - they will be returned to the client as well as being recorded.

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply