Link to home
Start Free TrialLog in
Avatar of pinaldave
pinaldaveFlag for India

asked on

List of SQL Error Codes/Messages for SQL 2000 and SQL 2005

Where can I find an entire list of the trappable SQL error codes?  Is there a web site that contains a list of the error codes.
ASKER CERTIFIED SOLUTION
Avatar of Lowfatspread
Lowfatspread
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pinaldave

ASKER

No I have not tried it.
Would you please give me link to BOL or search key word I should use to look up in BOL.
Or:
Select *
From master..sysmessages
Hi I just found error messages in BOL by searching Errors.
This can be closed. Requesting PAQ/Refund. I found them myself.
>>Requesting PAQ/Refund. I found them myself.<<
With all due respect, that is kind of pathetic.  Lowfatspread was the one that pointed you there in the first place.  Surely you are not so short of poinks that you cannot at least award points as a way of saying thanks?
Hi,
you may always refer sysmessages table of Master database when you want a list of Error Messages as said by ACPERKINS and if you wants a list of bug fixed after SQL Server 2005 SP1 http://support.microsoft.com/kb/913090 and what's new SQL Server 2005 SP2 http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm 

Regards
Hemantgiri S. Goswami
Microsoft SQL Server MVP