Skip to content

All SQL Server errors

Every error in the library, by number and alphabetically. 148 errors so far.

By error number

  1. 26 Error locating server or instance specified (SQL Network Interfaces)
  2. 40 Could not open a connection to SQL Server (Named Pipes Provider)
  3. 53 A network-related or instance-specific error (server not found)
  4. 102 Incorrect syntax near
  5. 105 Unclosed quotation mark after the character string
  6. 134 The variable name has already been declared
  7. 137 Must declare the scalar variable
  8. 156 Incorrect syntax near the keyword
  9. 201 Procedure or function expects a parameter which was not supplied
  10. 206 Operand type clash
  11. 207 Invalid column name
  12. 208 Invalid object name
  13. 209 Ambiguous column name
  14. 213 Column name or number of supplied values does not match table definition
  15. 217 Maximum stored procedure, function, trigger or view nesting level exceeded
  16. 220 Arithmetic overflow error for data type, value
  17. 229 The permission was denied on the object
  18. 233 No process is on the other end of the pipe (client error)
  19. 241 Conversion failed when converting date and/or time from character string
  20. 242 The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  21. 245 Conversion failed converting varchar value to int
  22. 258 The wait operation timed out / execution timeout expired (client error)
  23. 262 Permission denied, unable to run a statement
  24. 266 Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT
  25. 300 Permission was denied on object (for example VIEW SERVER STATE)
  26. 402 The data types are incompatible in the operator
  27. 468 Cannot resolve the collation conflict
  28. 512 Subquery returned more than 1 value
  29. 515 Cannot insert the value NULL into a NOT NULL column
  30. 530 The maximum recursion has been exhausted before statement completion
  31. 544 Cannot insert explicit value for identity column when IDENTITY_INSERT is OFF
  32. 547 Statement conflicted with a FOREIGN KEY or CHECK constraint
  33. 601 Could not continue scan with NOLOCK due to data movement
  34. 605 Attempt to fetch logical page failed; it belongs to a different allocation unit
  35. 701 There is insufficient system memory in resource pool to run this query
  36. 802 There is insufficient memory available in the buffer pool
  37. 823 The operating system returned an error during a read or write (I/O error)
  38. 824 SQL Server detected a logical consistency-based I/O error
  39. 825 A read of the file succeeded after failing (read-retry warning)
  40. 829 Page is marked RestorePending
  41. 916 The server principal is not able to access the database under the current security context
  42. 922 Database is being recovered; waiting until recovery is finished
  43. 924 Database is already open and can only have one user at a time
  44. 926 Database cannot be opened; it has been marked SUSPECT by recovery
  45. 942 Database cannot be opened because it is offline
  46. 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space
  47. 976 The target database is participating in an availability group and is not accessible for queries
  48. 983 Unable to access availability database because the replica is not PRIMARY or SECONDARY
  49. 1101 Could not allocate a new page because the filegroup is full
  50. 1105 Could not allocate space because the filegroup is full
  51. 1204 Cannot obtain a LOCK resource at this time
  52. 1205 Transaction was deadlocked and chosen as the victim
  53. 1222 Lock request time out period exceeded
  54. 1408 The remote copy of the database is not recovered far enough to join
  55. 1418 The server network address cannot be reached or does not exist
  56. 1785 Introducing FOREIGN KEY may cause cycles or multiple cascade paths
  57. 1813 Could not open new database; CREATE DATABASE is aborted
  58. 1834 The file cannot be overwritten because it is being used by another database
  59. 1919 Column is of a type that is invalid for use as a key column in an index
  60. 1934 Statement failed because SET options have incorrect settings
  61. 2570 Column value is out of range for its data type (data purity)
  62. 2601 Cannot insert duplicate key row with unique index
  63. 2627 Violation of PRIMARY KEY / UNIQUE constraint
  64. 2628 String or binary data would be truncated (named column)
  65. 2714 There is already an object named in the database
  66. 2760 The specified schema name either does not exist or you do not have permission
  67. 2812 Could not find stored procedure
  68. 3013 BACKUP DATABASE / RESTORE DATABASE is terminating abnormally
  69. 3101 Exclusive access could not be obtained because the database is in use
  70. 3117 The log or differential backup cannot be restored because no files are ready to roll forward
  71. 3154 The backup set holds a backup of a database other than the existing database
  72. 3156 File cannot be restored to the location; use WITH MOVE
  73. 3159 The tail of the log for the database has not been backed up
  74. 3169 The database was backed up on a server running an incompatible version
  75. 3183 RESTORE detected an error on a page as read from the backup set
  76. 3201 Cannot open backup device (operating system error)
  77. 3203 Read on the backup device failed
  78. 3241 The media family on device is incorrectly formed
  79. 3414 An error occurred during recovery, preventing the database from restarting
  80. 3701 Cannot drop the object because it does not exist or no permission
  81. 3702 Cannot drop database because it is currently in use
  82. 3902 The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION
  83. 3903 The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
  84. 3930 The current transaction cannot be committed (doomed transaction)
  85. 4060 Cannot open database requested by the login
  86. 4064 Cannot open user default database
  87. 4104 The multi-part identifier could not be bound
  88. 4121 Cannot find either column or the user-defined function or aggregate
  89. 4145 An expression of non-boolean type specified where a condition is expected
  90. 4208 The statement is not allowed while the recovery model is SIMPLE
  91. 4214 BACKUP LOG cannot be performed because there is no current database backup
  92. 4305 The log in this backup set begins at an LSN that is too recent to apply
  93. 4902 Cannot find the object because it does not exist or you do not have permissions
  94. 5030 The database could not be exclusively locked to perform the operation
  95. 5120 Unable to open the physical file (operating system error)
  96. 5123 CREATE FILE encountered an operating system error
  97. 5173 One or more files do not match the primary file of the database
  98. 6401 Cannot roll back; no transaction or savepoint of that name was found
  99. 7202 Could not find server in sys.servers
  100. 7303 Cannot initialize the data source object of OLE DB provider for linked server
  101. 7356 The OLE DB provider supplied inconsistent metadata for a column
  102. 7391 The provider was unable to begin a distributed transaction
  103. 7399 The OLE DB provider for linked server reported an error
  104. 7411 Server is not configured for DATA ACCESS (or RPC)
  105. 7416 Access to the remote server is denied because no login-mapping exists
  106. 8101 An explicit value for the identity column can only be specified with a column list and IDENTITY_INSERT ON
  107. 8114 Error converting data type X to Y
  108. 8115 Arithmetic overflow converting expression to data type
  109. 8116 Argument data type is invalid for argument of function
  110. 8120 Column is invalid in the select list because it is not in an aggregate or GROUP BY
  111. 8134 Divide by zero error encountered
  112. 8152 String or binary data would be truncated
  113. 8169 Conversion failed when converting from a character string to uniqueidentifier
  114. 8622 Query processor could not produce a query plan because of the hints
  115. 8623 The query processor ran out of internal resources and could not produce a query plan
  116. 8624 Internal Query Processor Error: could not produce a query plan
  117. 8645 A timeout occurred while waiting for memory resources to execute the query
  118. 8651 The requested memory grant was not available in resource pool
  119. 8921 Check terminated: a failure was detected while collecting facts
  120. 9001 The log for database is not available
  121. 9002 The transaction log for database is full
  122. 10054 An existing connection was forcibly closed by the remote host (client error)
  123. 10060 A connection attempt failed because the connected party did not properly respond
  124. 10061 TCP Provider: target machine actively refused it
  125. 14258 Cannot perform this operation while SQL Server Agent is starting
  126. 14262 The specified job (or other object) does not exist
  127. 14274 Cannot add, update or delete a job that originated from an MSX server
  128. 15023 User, group or role already exists in the current database
  129. 15138 The database principal owns a schema and cannot be dropped
  130. 15151 Cannot find the login or user because it does not exist or you do not have permission
  131. 15247 User does not have permission to perform this action
  132. 15434 Could not drop login as the user is currently logged in
  133. 17803 There was a memory allocation failure during connection establishment
  134. 17809 Could not connect because the maximum number of user connections has been reached
  135. 17890 A significant part of SQL Server process memory has been paged out
  136. 18452 Login failed: the login is from an untrusted domain
  137. 18456 Login failed for user
  138. 18461 Login failed: server is in single user mode
  139. 18470 Login failed: the account is disabled
  140. 18486 Login failed because the account is currently locked out
  141. 18487 Login failed: the password of the account has expired
  142. 18488 Login failed: the password of the account must be changed
  143. 19456 None of the IP addresses configured for the listener can be hosted by the server
  144. 22022 SQLServerAgent is not currently running so it cannot be notified of this action
  145. 35206 A connection timeout has occurred on a previously established connection to an availability replica
  146. 35250 The connection to the primary replica is not active
  147. 40615 Cannot open server requested by the login (Azure firewall)
  148. 41131 Failed to bring availability group online; the operation timed out

A to Z by message

A

B

C

D

E

F

I

L

M

N

O

P

Q

R

S

T

U

V