SQL Server engine errors

Database Engine15 error codes

Reference list of 15 SQL Server engine errors with meanings, common causes, and related context.

Severity

Showing 15 of 15 error codes

1205
High

Deadlock — the transaction was deadlocked on resources with another process

3 common causes
9002
High

Transaction Log Full — the database transaction log is full and no writes are possible

3 common causes
3201
High

Cannot open backup device — SQL Server cannot access the specified backup file or path

3 common causes
2601
Medium

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

3 common causes
2627
Medium

Constraint Violation — violation of a primary key or unique constraint

3 common causes
547
Medium

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

3 common causes
18456
Medium

Login Failed — the user login attempt failed

3 common causes
208
Medium

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

3 common causes
4060
Medium

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

3 common causes
229
Medium

Permission Denied — the current user lacks the required permission on the object

3 common causes
515
Medium

Cannot Insert NULL — a required column does not allow null values

3 common causes
8152
Medium

String or Binary Data Truncated — the value exceeds the column's defined length

3 common causes
1934
Medium

Update Conflict — the row was modified by another transaction after being read

3 common causes
102
Medium

Incorrect syntax near — a Transact-SQL syntax error was detected at the specified token

3 common causes
207
Medium

Invalid column name — referenced column does not exist in the table or result set

3 common causes