Does anyone know where to obtain a complete list of error codes which can occur in SQL Server For example : errror number 547 is a foreign key violation - where can I get a complete list of these numbers and there descritions
I can't find it in BOL or anywhere
Complete list of error codes
Jim1964
In BOL type in 'errors-SQL Server' in the search box in the index tab and they are listed starting with Error 10008 (DB-Library)
you can also take a look here
http://msdn.microsoft.com/library/default.asp url=/library/en-us/trblsql/tr_syserrors1a_10mx.asp
Denis the SQL Menace
http://sqlservercode.blogspot.com/