Caputre T-SQL Error Message in Stroed Proc

I need to capture the exact error message whenever the error occur while exe
ctuing the SQL query. I am able to get the error code and error message from
sysmessages table but error message contain some input values like '%ls'. I
need to get the exact mess
age.
Any help would be appricated.
Thanks in AdvancedNot possible: http://vyaskn.tripod.com/programming_faq.htm#q7
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Jitendra" <Jitendra@.discussions.microsoft.com> wrote in message
news:16CBD76A-C566-407E-A554-945809530259@.microsoft.com...
> I need to capture the exact error message whenever the error occur while
exectuing the SQL query. I am able to get the error code and error message
from sysmessages table but error message contain some input values like
'%ls'. I need to get the exact message.
> Any help would be appricated.
> Thanks in Advanced|||I dont know if there's a way where the stored proc woudl run to completion
if an error occurs. It would ideally exit and print the message. So unless
you want to say, direct your results (inc error message) to a txt file?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.