Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Need to trap Error Message Text in a Stored Procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-16 : 09:17:40
Vidya writes "I need to get the error message text and store it in another table. The problem with using @@ERROR and getting the corresponding message text from master..sysmessages is that it returns the template for the message and not the actual message thrown by SQL. Even if I use FORMATMESSAGE and pass @@ERROR to the function, it does not return the exact error message. Pleaseeee help!!!!!"
   

- Advertisement -