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)
 Error Logging In Stored Procedures

Author  Topic 

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2001-04-12 : 16:15:30
I'm using a stored procedure to select from one table and insert into another. I'm able to obtain @@error and look in the sysmessages table for the error message if an
error occurs.

I would like to know how I can detect on which row an error occurred, and how it is possible to get the error message as it's shown in the sql query analyzer instead of the message which is in sysmessages table.


   

- Advertisement -