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 Administration (2000)
 Error Handling

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-06 : 09:58:43
Ravi Chandran writes "How to obtain Error messages from Error number which i obtain using @@Error in sql scripts.
Plz do tell me is it possible to obtain the complete error messages from the sysmessages tables in master since the description in sysmessages table has place holders and hence the message obtained is incomplete.

If the above solutions is not possible plz provide me an alternative.


Thanks in Advance

with regards

Ravi Chandran"

nr
SQLTeam MVY

12543 Posts

Posted - 2001-12-06 : 11:11:52
see www.nigelrivett.com
Retreive a sql server error message

==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -