Where to find the list of error code and its messages for C#, Sql server ?

Question

How can I find a list of error codes for sql server, socket exceptions, web exceptions or any exception.

For sql server I am not able to find all the error codes in sysmessages like for instance errorcode 53, 17 so where do we find such codes?

For example System.Net.Sockets.SocketError sockererror is an enum which contains most of the socket errors, is there anything similar to this for sqlclient so tht we can capture sql server errors?

Answer 1

For SQL-Server, there seems to be a table for which I found a spec on MSDN, or is this what you meant?

SELECT * FROM sysmessages

afaik returns all the error-codes available on an MS SQL Server...

Answer 2

I can't speak for the other exception types you've listed but the SockException error codes are the same as those defined in Winsock2.h

For a list of Socket error code check out Windows Sockets Error Codes on MSDN: http://msdn.microsoft.com/en-us/library/ms740668%28VS.85%29.aspx