Hi All,
I was trying to find documenation for the error messages and the
corresponding error numbers for the errors that are raised by the .net data
provider for SQL Server on the Client side.

For example:
message when the provider times out: Timeout expired.  The timeout period
elapsed prior to completion of the operation or the server is not
responding.
error number is:-2
and
message when the provider cannot talk to sql server:SQL Server does not
exist or access denied.
error number is :17

I was trying to get a list of all the possible client side errors along with
their error numbers, so that we can handle them in our code if it is
appropriate.
Say for the timeout, we can retry couple of times by increasing the timeout
before giving up.
It would help us a lot if someone can  point me to any documentation
regarding this.

Thanks in advance.

PS: i did post this on the adonet newsgroup, but did not get the required
information, so I am trying my luck here

ADO.NET simply propagates all SQL Server errors to the client. What exactly
are you looking for?

Anyway, all of them reside in the sysmessages table in the mater database.
All 3831 of them.


ML

I smell a big, fat compiler bug
How do you rate this script
SET ROWCOUNT!
Table scan on 0 record temp table?
ATTENTION T-SQL GODS :: ALTER FUNCTION Permissions Issue