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)
 Get Run time Error Message from SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-10 : 00:43:15
Simon writes "Is there a way to get the "real" error message like the one that show up on your console/session editor?

I want to write an error handling procedure to capture the full text error message NOT just the @@error id and get the description from sysmessages. Because those are just "GENERIC" message ONLY, i.e. this will be t-sql, I need to get the SQLERRM alike message without using SQLCA.

Thanks."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-06-10 : 07:10:09
Take a look here:

http://www.nigelrivett.com/

Nigel has some code to do exactly what you want.

Go to Top of Page
   

- Advertisement -