Post reply

Error trapping with try catch

  • December 30, 2008 at 3:30 pm

    #133463

    has anyone come up with a way to do error trapping with try catch, where it is a distrubuted transaction. It looks like you can't use try catch with distributed

  • December 30, 2008 at 3:34 pm

    #919351

    Check the "severity" level

    From BOL:

    Errors with severity from 0 through 10 are informational messages and do not cause execution to jump from the CATCH block of a TRY…CATCH construct.

    Errors that terminate the database connection, usually with severity from 20 through 25, are not handled by the CATCH block because execution is aborted when the connection terminates.


    * Noel

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

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