SqlError.Number, what is it?

  • Thread starter Thread starter Kevin Burton
  • Start date Start date
K

Kevin Burton

I looked in the documentation to see if I could get a
numeric desciption of some SQL errors that I am receiving.
It looked like the SqlError.Number property just fit what
I needed. The problem is that the documentation indicates
that this property is an index into master.dbo.sysmessages
table. I looked into the table and could not find the
error number that I am getting. When the database is down
I get 17 from the SqlError property in the SqlException
that is thrown. The description is that the "SQL Server
does not exists or access denied." I look in the table and
I see an error 1 and 21 then it skips to over 100. I am
also getting an 11 with a description of "General network
error." The same comment this error does not seem to exist
in the sysmessages table. So what is this Number property?

Thank you.

Kevin
 
Back
Top