Steve Jones shows ERROR_MESSAGE()’s extended family:
I was working with a customer that was doing some error handling in procs and helped them do some error tracking. As we were working through things, I realized that some of functions working with errors operated differently than I expected.
Read on to learn more about these error functions and the proper way to use them.