Database Engine Errors
SQL Server diagnostic error codes organized by severity level and category. Each error includes error number, severity classification, and description. — Page 2 of 11.
Description resolution. To resolve, either fix MS DTC, restore from a full backup, or repair the database. 3434 20 Yes Cannot change sort order or locale. An unexpected failure occurred while trying t
Description 3453 16 No This version cannot redo any index creation or non-logged operation done by SQL Server 7.0. Further roll forward is not possible.
information about the cause, examine the Windows Event Log for a previous error that indicates the specific failure. For information about the cause of this occurrence of , examine the Windows Event L
Description use RESTORE to make that data available or drop the filegroups if you never need this data again. Dropping the filegroup results in a defunct filegroup. 3467 10 No Restore was successful b
Description 3615 10 No Table '%.*ls'. Scan count %d, logical reads %d, physical reads %d, page server reads %d, read-ahead reads %d, page server read-ahead reads %d, lob logical reads %d, lob physical
Description 3635 16 Yes An error occurred while processing '%ls' metadata for database id %d, file id %d, and transaction='%.*ls'. Additional Context='%ls'. Location='%hs'(%d).
Description 3710 16 No Cannot detach an opened database when the server is in minimally configured mode. 3716 16 No The %S_MSG '%.*ls' cannot be dropped because it is bound to one or more %S_MSG. 3717
Description primary key constraint on the table. Disable change tracking before dropping the constraint. 3736 16 No Cannot drop the %S_MSG '%.*ls' because it is being used for distribution. 3737 16 No
Description 3755 16 No Cannot drop a database with file snapshots on it. Please detach the database instead of dropping or delete the file snapshots and retry the drop.
'Description 3802 10 No Warning: The constraint "%.*ls" on "%.*ls"."%.*ls" may be impacted by the collation upgrade. Disable and enable WITH CHECK. 3803 10 No Warning: The index "%.*ls" on "%.*ls"."%.*'
Description and recreate the linked login before upgrade. 3816 16 No Upgrade of login '%.*ls' failed because its password hash is invalid. Update the login password before upgrade. 3817 10 No Warning:
Description 3859 10 No Warning: The system catalog was updated directly in database ID %d, most recently at %S_DATE. 3860 10 No Cannot upgrade database ID 32767. This ID value is reserved for SQL Serv
Description 3878 10 No The tiered memory memory-optimized configuration has been set to '%S_MSG'. Restart SQL server for the new setting to take effect. 3879 10 No Tiered memory for buffer pool starte
Description 3916 16 No Cannot use the COMMIT statement within an INSERT-EXEC statement unless BEGIN TRANSACTION is used first. 3917 16 No Session is bound to a transaction context that is in use. Othe
'Description 3932 16 No The save point name "%.*ls" that was provided is too long. The maximum allowed length is %d characters. 3933 16 No Cannot promote the transaction to a distributed transaction be'
Description to create the version. This might be timing related, so try the query again later. 3950 16 No Version store scan timed out when attempting to read the next row.
Description 3960 16 No Snapshot isolation transaction aborted due to update conflict.
Description 3969 16 No Distributed transaction is not supported while running SQL Server internal query. Check your logon trigger definition and remove any distributed transaction usage if any.
Description 3987 10 No SNAPSHOT ISOLATION is always enabled in this database. 3988 16 No New transaction is not allowed because there are other threads running in the session. 3989 16 No New request i
Description 4001 10 No Client sends a sp_reset_connection while there is still pending requests, server is disconnecting. 4002 16 No The incoming tabular data stream (TDS) protocol stream is incorrect
Description default %.*ls instead. 4018 16 No User default language %.*ls is not an official language name on this SQL Server. Using server-wide default %.*ls instead.
that has access to the database. For more information, see CREATE USER , ALTER ROLE , and ALTER SERVER ROLE You aren't running your application (for example, SSMS) as an administrator.
Description 4069 16 No The final value of the output parameter was null, and could not be sent to a 6.5 client expecting the parameter to be non-nullable. 4070 16 No More than 255 columns were specifi
Description 4080 16 No The incoming tabular data stream (TDS) protocol stream is incorrect. The TRACE TDS header contained errors.
If an alias has been provided for a table name in the FROM clause, you can only use the alias to prefix columns from the table. Match the column prefixes against the table names or alias names specifi
Description standalone expressions and subqueries are allowed here. 4116 16 No The function 'ntile' takes only a positive int or bigint expression as its input. 4117 16 No Cannot retrieve table data f
Description 4133 16 No Only a scalar expression may be specified as the argument to the RETURN statement.
'Description 4151 16 No The type of the first argument to NULLIF cannot be the NULL constant because the type of the first argument has to be known. 4152 16 No Type "%.*ls" is not a CLR type. 4153 16 N'
'Description 4173 16 No "%.*s" is not a valid scoring function name. 4174 16 No Delayed CLR type instantiation fetch value query may only reference column of a large object or large value type. 4175 16'
Description 4193 16 No '%.*ls' is not a valid window frame and cannot be used with the OVER clause. 4194 15 No RANGE is only supported with UNBOUNDED and CURRENT ROW window frame delimiters. 4195 16 N
, State: 1. <Datetime> Backup BACKUP failed to complete the command BACKUP LOG <db_name>. Check the backup application log for detailed messages.
Description not available for login because row versions are missing for transactions that were in-flight when the replica was recycled.
4. Use either the SQL Server complete version list tables or the Excel builds spreadsheet to determine the version of SQL Server that the build corresponds to. For example, 15.0.4236 maps to SQL Serve
Description RESTORE LOG statement WITH NORECOVERY. 4319 16 No A previous restore operation was interrupted and did not complete processing on file '%ls'. Either restore the backup set that was interru
Description 4333 16 No The database cannot be recovered because the log was not restored. 4334 16 No The named mark does not identify a valid LSN. 4335 16 No The specified STOPAT time is too early. Al
Description used to complete the transition to online. 4348 16 No The online restore to database '%ls' failed. It may be appropriate to perform an offline restore instead. An offline restore is initia
Description 4415 16 No View '%.*ls' is not updatable because either it was created WITH CHECK OPTION or it spans a view created WITH CHECK OPTION and the target table is referenced multiple times in t
Description 4433 16 No Cannot INSERT into partitioned view '%.*ls' because table '%.*ls' has an IDENTITY constraint. 4434 16 No Partitioned view '%.*ls' is not updatable because table '%.*ls' has an I
Description column '%.*ls' in table '%.*ls' has an IDENTITY constraint. 4451 16 No Views referencing tables on multiple servers are not updatable in the edition of this SQL Server instance '%.*ls'. Se
Description 4512 16 No Cannot schema bind %S_MSG '%.*ls' because name '%.*ls' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself. 4513 16 No Cannot s
Description 4602 14 No Only members of the sysadmin role can grant or revoke the CREATE DATABASE permission. 4604 16 No There is no such user or group '%.*ls' or you do not have permission. 4606 16 No
Description 4630 16 No The permission '%.*ls' is not supported in this version of SQL Server. Alternatively, use the %.*ls level '%.*ls' permission. 4631 16 No The permission '%.*ls' is not supported
Description that you are using a supported client application programming interface (API). 4805 17 No The front-end tool you are using does not support bulk load from host.
'Description 4822 16 No Cannot bulk load. Invalid number of columns in the format file "%s". 4823 16 No Cannot bulk load. Invalid column number in the format file "%s". 4824 16 No Cannot bulk load. Inv'
'Description 4839 16 No Cannot perform the bulk load. Invalid collation name for source column %d in the format file "%s". 4840 16 No The bulk data source provider string has an invalid %ls property va'
Description 4864 16 No Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row %d, column %d (%ls).
'Description 4882 16 No Cannot bulk load. A prefix length, field length, or terminator is required for the source column %d in the format file "%s". 4883 16 No The XML reader returned 0x%08X for the in'
Description change tracking before using ALTER TABLE SWITCH.
Description 4916 16 No Could not enable or disable the constraint. See previous errors. 4917 16 No Constraint '%.*ls' does not exist. 4918 16 No ALTER TABLE SWITCH statement failed because the table '
Description 4938 16 No ALTER TABLE SWITCH statement failed. Partition %d of %S_MSG '%.*ls' is in filegroup '%.*ls' and partition %d of %S_MSG '%.*ls' is in filegroup '%.*ls'. 4939 16 No ALTER TABLE SW
Description '%.*ls'. 4954 16 No ALTER TABLE SWITCH statement failed. The table '%.*ls' has inline limit of %d for text in row data which is different from value %d used by table '%.*ls'. 4955 16 No AL
Description key. 4969 16 No ALTER TABLE SWITCH statement failed.
Description 4982 16 No ALTER TABLE SWITCH statement failed. Check constraints of source table '%.*ls' allow values that are not allowed by range defined by partition %d on target table '%.*ls'. 4983 1
Description 4996 16 No Change tracking is already enabled for table '%.*ls'. 4997 16 No Cannot enable change tracking on table '%.*ls'. Change tracking requires a primary key on the table.
Description 5001 16 No User must be in the master database. 5002 16 No Database '%.*ls' does not exist. Verify the name in sys.databases and try the operation again.
Description 5020 16 No The primary data or log file cannot be removed from a database. 5021 10 No The %S_MSG name '%.*ls' has been set. 5022 16 No Log file '%ls' for this database is already active. 5
If or succeeds to the IP address, but fails to the , there's likely a DNS or name resolution issue. See Check for name resolution issues .
'In this case OS error = 0x139f, which is 5023 in decimal. If you go to a Command Prompt and type to look up this OS error, you''ll get: "The group or resource isn''t in the correct state to perform the '
Description 5039 16 No MODIFY FILE failed. Specified size is less than or equal to current size. 5040 16 No MODIFY FILE failed for database '%.*ls', file id %d.
'Description 5062 16 No The option "%.*ls" conflicts with another requested option. The options cannot both be requested at the same time. 5063 16 No Database ''%.*ls'' is in warm standby. A warm-standby'
'Description 5080 16 No Vardecimal storage format cannot be disabled for database "%.*ls" because the database is not under simple recovery model. Change the database recovery model to simple and then '
'Description 5096 16 No The recovery model cannot be changed to SIMPLE when any files are subject to a RESTORE PAGE operation. Complete the restore sequence involving file "%ls" before attempting to tr'
'Description 5118 16 No The file "%ls" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. 5119 16 No Cannot make the file "%.*ls" a sparse file. Make'
'Description 5138 16 No Trailing space is not allowed in SQL file name ''%.*ls'' on cloud storage. 5139 16 No Operation (%.*ls) failed on ''%.*ls''. Operating system error %d: "%ls" 5140 16 No Failed to lo'
Description this is an existing database, the file may be corrupted and should be restored from a backup. 5174 16 No Each file size must be greater than or equal to 512 KB. 5175 10 Yes The file %.*ls
file ID being referenced is < 0 or is not a valid file ID in a database (per the valid file IDs listed in system catalog views such as sys.database_files), then a 5180 error can be encountered.
Description 5189 16 No Encountered error (NT status code 0x%x) while attempting to perform undo for transactional file system resource manager '%.*ls'. 5190 16 No Encountered error (NT status code 0x%
Description 5208 10 No %.*ls: Page %d:%d could not be moved because it is a work file page. 5209 10 No %.*ls: Page %d:%d could not be moved because it is a dedicated allocation page. 5210 10 No %.*ls:
Description 5226 10 No %.*ls: Page %d:%d (type UNLINKED_REORG_PAGE) could not be deallocated. 5227 10 No %.*ls: Page %d:%d (type BULK_OPERATION_PAGE) could not be deallocated. 5228 16 No Table error:
Description 5241 10 No File ID %d of database ID %d cannot be shrunk as the target shrink size (%I64d KB) is greater than the actual file size (%I64d KB).
Description 5257 10 No %.*ls: File ID %d of database ID %d was skipped because the file size was changed in the middle of shrink operation. 5258 10 No %.*ls: Heap page %d:%d could not be moved because
Description 5274 16 No Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID.
Description 5288 16 No Columnstore index has one or more data values that do not match data values in a dictionary. Please run DBCC CHECKDB for more info. 5289 16 No Clustered columnstore index '%.*ls
Description 5302 16 No Mutator '%.*ls' on '%.*ls' cannot be called on a null value. 5303 16 No The result of applying mutator '%.*ls' on CLR type '%.*ls' cannot be a null value. 5304 16 No Bulk copy f
Description 5319 16 No Aggregates are not allowed in a WHEN clause of a MERGE statement. 5321 16 No The '%ls' function is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT
Description 5333 16 No The identifier '%.*ls' cannot be bound. Only source columns and columns in the clause scope are allowed in the 'WHEN NOT MATCHED' clause of a MERGE statement.
Description 5351 16 No Partial file cannot be provided together with TABLESAMPLE clause. 5352 16 No Missing update assignment in update with action hint. 5353 16 No Parser version '%ls' is not support
Description 5372 16 No The specified bulk option '%ls' is not supported for file format '%ls'. Review the documentation for supported options.
Description 5510 15 No LOG ON cannot be used for non-FILESTREAM file group '%.*ls'. 5511 23 No FILESTREAM's file system log record '%.*ls' under log folder '%.*ls' is corrupted. 5512 16 Yes x%x (%ls)
Description 5527 16 No The primary FILESTREAM log file cannot be dropped because other FILESTREAM filegroups exist.
Description 5544 10 No FILESTREAM: effective level = %d (remote access enabled), configured level = %d, file system access share name = '%.*ls'. 5545 10 No FILESTREAM: connected to kernel driver %ls.
Description 5570 16 No FILESTREAM Failed to find the garbage collection table. 5571 23 No Internal FILESTREAM error: failed to access the garbage collection table.
Description 5586 10 No The FILESTREAM feature is already configured to the specified level. No change has been made.
Description 5701 10 No Changed database context to '%.*ls'. 5702 10 No SQL Server is terminating this process. 5703 10 No Changed language setting to %.*ls. 5803 10 No Unknown configuration (id = %d)
Description 5840 16 No The service broker message forward mode is invalid. 5841 16 No The default full-text language is not supported by the full-text search component.
Description processors by using ALTER SERVER CONFIGURATION. 5860 10 No Affinity changed for node %d: from 0x%0*I64x:%u to 0x%0*I64x:%u. This is an informational message only. No user action is require
Description 5901 16 No One or more recovery units belonging to database '%.*ls' failed to generate a checkpoint.
Description 6001 10 No SHUTDOWN is waiting for %d process(es) to complete. 6004 10 No User does not have permission to perform this action. 6005 10 No SHUTDOWN is in progress.
Description 6115 16 No KILL command cannot be used inside user transactions. 6117 16 No There is a connection associated with the distributed transaction with UOW %s.
Description 6211 16 No %s ASSEMBLY failed because type '%.*ls' in %.*ls assembly '%.*ls' has a static field '%.*ls'. Attributes of static fields in %.*ls assemblies must be marked readonly in Visual C
'Description serialization types cannot have fields marked with "System.NonSerializedAttribute". 6225 16 No Type "%.*ls.%.*ls" is marked for native serialization, but field "%.*ls" of type "%.*ls.%.*ls'
'Description 6239 16 No %s ASSEMBLY failed because type "%.*ls" in assembly "%.*ls" has an invalid custom attribute "%.*ls". 6240 16 No ALTER ASSEMBLY failed because the function ''%s'' of type ''%s'' no l'
'Description is %d. 6257 16 No CREATE ASSEMBLY for assembly ''%.*ls'' failed because the assembly is built for an unsupported version of the Common Language Runtime. 6258 16 No Function signature of "Fil'
Description 6274 16 No ALTER ASSEMBLY failed because the serialization format of type '%s' would change in the updated assembly. Persisted types are not allowed to change serialization formats. 6275 1
'Description 6288 16 No ALTER ASSEMBLY has marked data as unchecked in one or more objects in database "%.*ls". Refer to column "has_unchecked_assembly_data" from system views "sys.tables" and "sys.vie'
Description 6309 16 No XML well-formedness check: the data for node '%.*ls' contains a character (0x%04X) which is not allowed in XML. 6310 16 No Altering existing schema components is not allowed. Th
Description 6327 16 No The specified xml schema collection ID is not valid: %d 6328 16 No Specified collection '%.*ls' cannot be dropped because it is used by %S_MSG '%ls'.
Description 6344 16 No The primary xml index '%.*ls' does not exist on table '%.*ls' column '%.*ls'. 6345 16 No The sparse column set '%.*ls' in the table '%.*ls' cannot be indexed by an XML index. 63
Description the schema binding before trying to alter the collection. 6364 16 No ALTER SCHEMA COLLECTION failed.
Description 6379 16 No selective XML index '%.*ls' already exists on column '%.*ls' in table '%.*ls'. Multiple selective XML indexes per column are not allowed. 6380 16 No Path '%.*ls'.