SQL 2005. Is there any way to re-raise a system error that occurs within a
TRY block as the system error? Within the CATCH block I can identify the
error number via the ERROR_NUMBER() function and I can include that number
within the error message when I re-raise the error, but client code then has
to parse the text to identify the specific error - not a good idea. I can
explicitly re-raise a user defined error (> 50,000), but I can't re-raise a
system error (e.g., 547, FK violation). Any solution?
Have you considered using the return value?
... do error-handling