Database Engine Errors
SQL Server diagnostic error codes organized by severity level and category. Each error includes error number, severity classification, and description. — Page 3 of 11.
Description combination of large values, the insert/update operation will fail. 6396 16 No The number of promoted paths for selective XML index '%.*ls' exceeds the maximum of %d. 6397 16 No Path '%.*l
Description MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online.
Server: Msg 6522, Level 16, State 2, Line 1 A .NET Framework error occurred during execution of user defined routine or aggregate 'getsid': System.IO.FileLoadException: Could not load file or assembly
Description 6533 16 Yes AppDomain %.*ls was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource. %.*ls 6534 16 Yes A
Description 6548 16 No CREATE ASSEMBLY failed because the assembly references assembly '%.*ls', which is owned by another user.
Description 6566 16 No %s ASSEMBLY failed because the assembly source parameter %d is not a valid expression.
Description 6585 16 No Could not impersonate the client during assembly file operation. 6586 16 No Assembly '%.*ls' could not be installed because existing policy would keep it from being used. 6587 1
'Description 6608 16 No Failed to instantiate class "%ls". Verify that Msxmlsql.dll exists in the SQL Server installation. 6609 16 No Invalid data type for the column "%ls". Allowed data types are CHAR'
'Description required version. Found version "%d.%d.%d". Require version "%d.%d.%d". 6634 16 No OpenXML cannot be used as the target of a DML or OUTPUT INTO operation. 6635 16 No The compressed showpla'
Description 6805 16 No FOR XML EXPLICIT stack overflow occurred. Circular parent tag relationships are not allowed. 6806 16 No Undeclared tag ID %d is used in a FOR XML EXPLICIT query. 6807 16 No Unde
Description XML. 6826 16 No Every IDREFS or NMTOKENS column in a FOR XML EXPLICIT query must appear in a separate SELECT clause, and the instances must be ordered directly after the element to which t
Description 6841 16 No FOR XML could not serialize the data for node '%.*ls' because it contains a character (0x%04X) which is not allowed in XML.
Description 6856 16 No FOR XML row XML tag name contains an invalid XML identifier; '%c'(0x%04X) is the first character at fault. 6857 16 No FOR XML root XML tag name contains an invalid XML identifie
Description XSINIL option of FOR XML. 6874 16 No Empty URI is not allowed in WITH XMLNAMESPACES clause. 6875 16 No URI '%.*ls' used in WITH XMLNAMESPACES is invalid. '%c'(0x%04X) is the first characte
Description 6913 16 No XML Validation: Declaration not found for element '%s'.
Description 6931 16 No XML Validation: IDREF constraint check failed. Found attribute named '%.*ls' with reference to ID value '%.*ls', which does not exist 6932 16 No Invalid definition for element o
Description 6947 16 No XML Validation: Multiple ID attributes found on a single element. %S_MSG %s 6948 16 No Invalid type definition for type '%s', 'minLength' can not be greater than 'Length' 6949 1
Description 6963 16 No 'Default' or 'Fixed' value is longer than allowed, maximum length allowed is 4000 characters : '%s' 6964 16 No Facet value is longer than allowed, maximum length allowed is 4000
Description 6978 16 No Invalid item type for list type '%s'.
Description 6993 16 No Value constraint on use of attribute '%s' must be consistent with value constraint on its declaration. 6994 16 No Invalid restriction for type '%s'.
Description 7000 16 No OPENXML document handle parameter must be of data type int. 7001 16 No OPENXML flags parameter must be of data type int. 7002 16 No OPENXML XPath must be of a string data type,
If database corruption is the cause for this problem, then and/or should report errors. However, these commands will not report Msg 7105. The errors you encounter from CHECKDB will depend on what is d
Description 7109 16 Yes The Database ID %d, Page %S_PGID, slot %d for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC
Description 7141 16 No Must create orphaned text inside a user transaction. 7143 16 No Invalid locator de-referenced. 7144 16 No A text/ntext/image column referenced by a persisted or indexed computed
'Description server. 7305 16 No Cannot create a statement object using OLE DB provider "%ls" for linked server "%ls". 7306 16 No Cannot open the table "%ls" from OLE DB provider "%ls" for linked server'
'Description 7320 16 No Cannot execute the query "%ls" against OLE DB provider "%ls" for linked server "%ls". %ls 7321 16 No An error occurred while preparing the query "%ls" for execution against OLE '
'Description 7344 16 No The OLE DB provider "%ls" for linked server "%ls" could not %ls table "%ls" because of column "%ls". %ls 7345 16 No The OLE DB provider "%ls" for linked server "%ls" could not d'
'Description 7358 16 No Cannot execute the query. The OLE DB provider "%ls" for linked server "%ls" did not provide an appropriate interface to access the text, ntext, or image column "%ls.%ls". 7359 1'
Description 7376 16 No Could not enforce the remote join hint for this query. 7377 16 No Cannot specify an index hint for a remote data source.
If you receive from a process such as SQL Server replication or SQL Server Integration Services (SSIS), you might also receive the error message if the code contains a statement.
Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB' reported an error. [OLE/DB provider returned message: Timeout expired] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitiali
'Description 7410 16 Yes Remote access is not allowed for impersonated security context. 7411 16 Yes Server ''%.*ls'' is not configured for %ls. 7412 16 Yes OLE DB provider "%ls" for linked server "%ls" '
'Description interface, but returned "%ls" for "%ls". 7429 10 Yes %hs SQL Server Remote Metadata Gather Time for Table %s.%s:%hs, CPU time = %lu ms, elapsed time = %lu ms. 7430 16 Yes Out-of-process us'
Description Error message: '%ls'. 7446 16 Yes Linked Server use MSI mode Microsoft Entra ID authentication functionality is disabled on the service side and therefore cannot be used. 7447 16 Yes Linke
'Description 7608 16 No An unknown full-text failure (0x%x) occurred during "%hs". 7609 17 No Full-Text Search is not installed, or a full-text component cannot be loaded. 7610 16 No Access is denied t'
'Description 7627 16 No Cannot create the full-text catalog in the directory "%.*ls" for the clustered server. Only directories on a disk in the cluster group of the server can be used. 7628 10 No Warn'
Description 7641 16 No Full-Text catalog '%ls' does not exist in database '%.*ls' or user does not have permission to perform this action.
Description 7657 10 No Warning: Table or indexed view '%.*ls' has full-text indexed columns that are of type image, text, or ntext.
Description 7673 10 No Warning: Full-text change tracking is currently disabled for table or indexed view '%.*ls'.
Description 7690 16 No Full-text operation failed because database is read only. 7691 16 No Access is denied to full-text log path. Full-text logging is disabled for database '%ls', catalog '%ls' (dat
Description 7710 10 No Warning: The partition scheme '%.*ls' does not have any next used filegroup. Partition scheme has not been changed.
Description corresponding parameter in partition function '%.*ls'. 7728 16 No Invalid partition range: %d TO %d. Lower bound must not be greater than upper bound. 7729 16 No Cannot specify partition n
Description 7803 15 No The clause %.*ls can not be used in the %.*ls statement. 7804 15 No %.*ls and %.*ls can not share the same value. 7805 16 No The parameter SITE can not be prefixed by a scheme s
'Description 7822 16 No An unexpected XML node "%.*ls" (in the namespace "%.*ls") was found in the "%.*ls" element (in the "%.*ls" namespace) of the SOAP request. 7823 16 No The "%.*ls" XML element (in'
'Description 7848 15 No An invalid or unsupported localeId was specified for parameter "%.*ls". 7849 15 No Invalid sqlCompareOptions were specified for parameter "%.*ls". 7850 16 No The SQL Server Serv'
Description 7864 16 No CREATE/ALTER ENDPOINT cannot be used to update the endpoint with this information. The Dedicated Administrator Connection endpoint is reserved and cannot be updated. 7865 16 No
Description 7880 10 No SQL Server has successfully finished closing sessions and connections. 7881 10 No SQL Server was unable to close sessions and connections in a reasonable amount of time and is a
Description 7893 15 No Parameter '%.*ls': Incompatible XML attributes were present. The '%.*ls' attribute and the '%.*ls' attribute may not both be present on a parameter value node of type '%.*ls' (i
7. Then find the file identified in the error message (for example NO_USER_FILE_SHOULD_BE_HERE.txt), and make a copy of this file to a temporary directory as a backup. 8.
'Description 7908 16 No Table error: The file "%.*ls" in the rowset directory ID %.*ls is not a valid FILESTREAM file in container ID %d. 7909 20 No The emergency-mode repair failed.You must restore fr'
Description pages used in %I64d dedicated extents. 7926 16 No Check statement aborted.
'Description 7940 16 No System databases master, model, msdb, and tempdb cannot be detached. 7941 16 No Table error: object ID %d, index ID %d, partition ID %I64d processing encountered file name "%.*l'
Description 7961 16 No Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) , page ID %S_PGID, row ID %d.
Description 7980 10 No Oldest distributed LSN : (%d:%d:%d) 7981 16 No Clustered columnstore index '%.*ls' on table '%.*ls', column '%.*ls' has one or more values out of range for data type '%.*ls'. Re
Description value '%.*hs'. 7999 16 No Could not find any index named '%.*ls' for table '%.*ls'. Database Engine events and errors Understanding Database Engine errors Cause and resolution of Database
Description 8001 16 No The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Meta-information is invalid for the Sql Variant parameter. 8002 16 No The incomi
'Description 8013 16 No The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter %d ("%.*ls"): Data type 0x%02X (sql_variant) has an invalid instance l'
'Description 8024 16 No The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter %d ("%.*ls"): Data type 0x%02X (sql_variant) has an invalid collation '
'Description 8034 16 No The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter %d ("%.*ls"), row %I64d, column %d: Data type 0x%02X (sql'
Description %.*ls. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. 8044 16 No The incoming tabular data stream (TDS)
Description %I64d, column %d: Data type 0x%02X (user-defined table type) timestamp column is required to be default.
'Description 8063 16 No The incoming tabular data stream (TDS) remote procedure call stream is sending an unlimited length CLR type. Parameter %d ("%.*ls") is defined as type %.*ls. This type is not su'
Description 8107 16 No IDENTITY_INSERT is already ON for table '%.*ls.%.*ls.%.*ls'. Cannot perform SET operation for table '%.*ls'. 8108 16 No Cannot add identity column, using the SELECT INTO stateme
'Description 8126 16 No Column "%.*ls.%.*ls" is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause. 8127 16 No Column "%.*ls.%.*ls" is i'
Description 8147 16 No Could not create IDENTITY attribute on nullable column '%.*ls', table '%.*ls'. 8148 16 No More than one column %ls %S_MSG specified for column '%.*ls', table '%.*ls'. 8149 16 No
Description 8169 16 No Conversion failed when converting from a character string to uniqueidentifier. 8170 16 No Insufficient result space to convert uniqueidentifier value to char. 8171 16 No Hint '%
Description 8189 16 No You do not have permission to run '%ls'. 8190 16 No Cannot compile replication filter procedure without defining table being filtered. 8191 16 No Replication filter procedures c
Description option. The preferred method of storing large data is through use of the varchar(max), nvarchar(max) and varbinary(max) data types. 8306 10 No Use of level0type with value 'TYPE' in proced
Description 8319 16 No The operating system kernel object '%ls' already exists. It's not owned by the SQL Server service account. SQL Server performance counters are disabled. 8320 10 No @@REMSERVER w
Description 8379 10 No Old style RAISERROR (Format: RAISERROR integer string) will be removed in the next version of SQL Server. Avoid using this in new development work, and plan to modify applicatio
Description new development work, and plan to modify applications that currently use it. 8394 10 No Usage of deprecated index option syntax.
Description 8409 16 No This message could not be delivered because the targeted service does not support the service contract. Targeted service: '%.*ls', service contract: '%.*ls'.
Description endpoint state is '%ls'. 8430 16 No The message body failed the configured validation. 8431 16 No The message type '%.*ls' is not part of the service contract.
Description 8450 16 No Assignments in the RECEIVE projection are not allowed in conjunction with the INTO clause. 8451 16 No The conversation handle '%.*ls' at position %d appears more than once. 8457
Description database, restore the database from a clean backup. If no clean backup is available, consider running DBCC CHECKDB. Note that DBCC CHECKDB may remove data to repair the database. 8479 16 N
Description 8511 16 Yes Unknown isolation level 0x%x requested from Microsoft Distributed Transaction Coordinator (MS DTC).
Description 8529 16 No Unable to extract the Kernel Transaction Manager (KTM) transaction handle from the Microsoft Distributed Transaction Coordinator (MS DTC) transaction: 0x%x.
Description 8546 10 Yes Unable to load Microsoft Distributed Transaction Coordinator (MS DTC) library. This error indicates that MS DTC is not installed. Install MS DTC to proceed. 8547 10 Yes Resourc
Description once the connection is re-established. This is an informational message only. No user action is required.
Description 8579 10 Yes Testing connection to '%ls' ('%ls') succeeded. 8580 16 Yes The provided remote transaction manager whereabouts are invalid.
Description 8619 16 No The query processor could not produce a query plan because a worktable is required, and its minimum row size exceeds the maximum allowable of %d bytes.
Description distributed queries. 8637 16 No The query processor could not produce a query plan because a USE PLAN hint was used for a query that modifies data while the target table of the modificatio
Description 8656 16 No The query processor could not produce a query plan. Resubmit the query after disabling trace flag %d.
Description 8666 10 No Warning: The optimizer cannot use the index because the select list of the view contains a non-aggregate expression.
Description new COUNT_BIG aggregate over such nullable expression. 8679 16 No The UPDATE/DELETE statement attempted to modify the same row more than once. Refine the statement to ensure a target row i
Description existing database. 8690 16 No Query cannot be compiled because USE PLAN hint conflicts with hint %ls. Consider removing hint %ls.
Description you continue to see this error, consider using Repeatable Read or higher isolation level. 8709 16 No Error due to negative or NULL window delimiter.
Description 8724 15 No Cannot execute query. Table-valued or OPENROWSET function '%.*ls' cannot be specified in the TABLE HINT clause. 8725 17 No Subproc thread aborted during parallel query execution
Description 8741 17 No An error occurred when reading data moved from one distribution to another. Additional details: '%s'. Try to run the query again. If the error persists, contact support. 8742 17
Description 8759 16 No Get length of node list from XML DOM node failed.
Description 8778 16 No Query execution has been aborted because the ABORT_QUERY_EXECUTION hint was specified. 8779 17 No Failed to initialize in-memory storage for operator metrics feedback. 8780 16 N
Description 8903 16 No Extent %S_PGID in database ID %d is allocated in both GAM %S_PGID and SGAM %S_PGID. 8904 16 No Extent %S_PGID in database ID %d is allocated by more than one allocation object.
Description 8918 10 No (number of mixed extents = %I64d, mixed pages = %I64d) in this database. 8919 16 No Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls): The record c
Description 8933 16 No Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). The low key value on page %S_PGID (level %d) is not >= the key value in the parent
Description 8945 16 No Table error: Object ID %d, index ID %d will be rebuilt. 8946 16 No Table error: Allocation page %S_PGID has invalid %ls page header values. Type is %d. Check type, alloc unit ID
Description 8960 16 No Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). Page %S_PGID, slot %d, column %d is not a valid complex column.
accompanied by one or more instances of . State 3 Basic system table checks of the core storage engine system tables failed. This message is accompanied by one or more instances of , 7985, 7986 , 798
Description points to the forwarded row page %S_PGID, slot %d, which correctly refers back to page %S_PGID, slot %d. 8973 16 No CHECKTABLE object ID %d, index ID %d, partition ID %I64d, alloc unit ID
Description 8984 16 No Table error: object ID %d, index ID %d, partition ID %I64d. A row should be on partition number %d but was found in partition number %d.
Scenario 2 The following warning message is returned when you execute the command after a system table is manually updated: DBCC results for ' '. Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg