Number / description of sql error

Hi

All Sql Server errors have a number. Is there any MS or MSDN website or any .net method in which I can see these errors?

Thanks a lot

switch (error.Number)

{

case 17:

msgErro =...

break;

case 4060:

msgErro =...

break;

case 18456:

msgErro = ....

break;

default:

msgErro = exSql.Message;

break;

}

Roberot,

The SQL Server error codes are in SQL Server Books On-line, which is part of the documentation that's installed with SQL Server. You may try googling "SQL Server error codes" if you don't have access to the documentation.

Good luck

|||

Roberot:

Hi

All Sql Server errors have a number. Is there any MS or MSDN website or any .net method in which I can see these errors?

Thanks a lot

switch (error.Number)

{

case 17:

msgErro =...

break;

case 4060:

msgErro =...

break;

case 18456:

msgErro = ....

break;

default:

msgErro = exSql.Message;

break;

}

Try the link below to download the BOL(books online). Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en