Unfortunately, there is nothing that you can do from T-SQL. Many many
customers are requesting this feature. I don't know when these SQL Server
program managers will decide to implement this SMALL, and SIMPLE feature.
It's surprising to see that we don't have such an obvious feature.
Check out http://members.tripod.com/~vyaskn/SQLServerRes.html for SQL Server
resources on the net.
Always under construction!!!
Is it possible to trap a fully formatted error message within SQL 7.0
find a way to get a fully formatted error message corresponding to the
sysmessages is not much of a help as it just is the template for the
error, not a fully formated error.