SqlError.Number, what is it?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top