jellybean (7/26/2016)
Hi,I'm using SQL Sever 2014. I'm wondering is it possible to get the ERROR_MESSAGE() statement to display the full error message. I know it only displays the last error if there is more than 1 but I would really like to capture all the error if more than 1 exists inside the catch area ofa sql try catch?
Comments appreciate,
J.
If your code is using TRY ... CATCH, control is passed to CATCH on the first error ... so there are not multiple messages to be caught. Or am I missing something? Can you provide sample code to demonstrate your request?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.