VB and VBA Users Source Code: Returning a description for an SQL error number

VB/VBA Source Code
Returning a description for an SQL error number

By:	Andrew Baker
Email (spam proof):	Email the originator of this post
Date:	Friday, May 04, 2001
Hits:	569
Category:	Database/SQL/ADO

Article:
To convert an SQL error number (i.e. the number found in the global variable @@error) into an error description use the following SQL: select description from master.dbo.sysmessages where error = @@error
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder