SQL Server 2005 Error Numbers List

[dhlp]

Hello,

I am catching sql exceptions in vb.net and wondering if there is a list somewhere of all sql exception error numbers that I can refer to, to catch and handle specific errors.

I have searched a few places on the web but haven't found a list.

Thanks,

Dave

 

[fxthoth]

Hello,
list of all errors is here for SQL Server 2005 or 2008:

select * from sys.messages

and here for SQL Server 2000:

select * from master.dbo.sysmessages

But you can catch errors in SQL Server 2005 or 2008 in T-SQL. Here is demonstration how TRY/CATCH works:
[URL unfurl="true"]http://www.codeproject.com/KB/database/try_catch.aspx[/url]