SQL Server error codes
24 codes — tap one for its meaning, causes, and fix steps.
- 10054an existing connection was forcibly closed by the remote host — network reset
- 102incorrect syntax near — the parser encountered an unexpected token
- 1105could not allocate space for object — the filegroup or disk is full
- 1205transaction was deadlocked and chosen as the deadlock victim — rolled back
- 156incorrect syntax near a keyword — a reserved word was used improperly
- 17142SQL Server service is paused — new connections are refused
- 18456login failed for user — authentication rejected
- 207invalid column name — the column does not exist on the referenced table
- 208invalid object name — the table or view does not exist
- 229execute permission denied on object — the user lacks the required privilege
- 233no process is on the other end of the pipe — connection broken
- 245conversion failed when converting to a data type — type mismatch
- 2601cannot insert duplicate key row in object with unique index — index duplicate violation
- 262CREATE DATABASE permission denied in database — insufficient privilege for DDL
- 2627violation of PRIMARY KEY or UNIQUE constraint — duplicate key value
- 3621the statement has been terminated — a prior error caused the batch to abort
- 4060cannot open database requested in login — database does not exist or access denied
- 40615cannot open server requested by the login — Azure SQL firewall rule missing
- 515cannot insert the value NULL into column — NOT NULL constraint violated
- 53a network path was not found — the client could not reach the server
- 547the INSERT or UPDATE statement conflicted with a FOREIGN KEY or CHECK constraint
- 8134divide by zero error encountered — division by zero in a calculation
- 8152string or binary data would be truncated — value is too long for the column
- 9002the transaction log for database is full — log space exhausted