SqlError.Number descriptions

Question

Where i can get all the descriptions of the SqlError.Number collection? This are throwed by SqlException

Answer 1

From sys.messages in your database. Since you can add your own errors in SQL Server (via sp_addmessage), there is no definitive list. Also, the pre-defined list (below 50000) can differ (grow) per database version.

(or do you just mean .Message on each SqlError instance?)

Answer 2

SELECT Description FROM master..sysmessages