SQL Server engine-errors Error Codes

Deadlock — the transaction was deadlocked on resources with another process

Duplicate Key — an attempt to insert a duplicate value into a unique index

Constraint Violation — violation of a primary key or unique constraint

Conflicted Constraint — the statement conflicted with a foreign key or check constraint

Login Failed — the user login attempt failed

Invalid Object — the specified object name is invalid or does not exist

Cannot Open Database — the database requested by the login cannot be opened