Tag: Timeout
SQL Error codes…..!
by DotCom on Apr.07, 2008, under Engineers Corner
Recently have noticed it was a little more of a challenge to find the actual error codes you might have to handle in a case of timeouts or connectivity issues.  Normally you can easily get a list of error numbers/messages by viewing the master.dbo.sysmessages table. But what error codes do you get in cases you can’t even communicate properly with the DB itself. Well it is hard to find the answer to these. Which I think is a little wierd since I can see many use cases of where I would want to determine wether its a connection error or processing error in order to know how to proceed on indexed data. Anyway the list I could come up with is as follows, not sure how accurate it is since there is very little information around it.
-3: ZeroBytes
-2: Timeout
-1: Unknown
1: InsufficientMemory
2: AccessDenied
3: ConnectionBusy
4: ConnectionBroken
5: ConnectionLimit
6: ServerNotFound
7: NetworkNotFound
8: InsufficientResources
9: NetworkBusy
10: NetworkAccessDenied
11: GeneralError
12: IncorrectMode
13: NameNotFound
14: InvalidConnection
15: ReadWriteError
16: TooManyHandles
17: ServerError
18: SSLError
19: EncryptionError
20: EncryptionNotSupported
