Home Forums SQL Server 2014 Development - SQL Server 2014 Error handling with a called stored procedure Reply To: Error handling with a called stored procedure

  • October 17, 2022 at 11:26 am

    #4100458

    wrote:

    zoah666 wrote:

    Stored procedure OUTER_TEST calls stored procedure INNER_TEST.

    If an error in INNER_TEST, how do I capture the error message (to store in a table). When I have a try-catch in OUTER_TEST, I can only access a later error message and not the initial one from INNER_TEST

    I got this,..

    What, exactly, have you got?

    Did you understand my code? A very simple modification to it would achieve your desired outcome.

    • This reply was modified 2 years, 11 months ago by Phil Parkin.