Troubleshooting
Errors 7000 - 7999
| Error | Severity | Description (Message Text) |
| 7000 | 16 | OPENXML document handle parameter must be of data type int. |
| 7001 | 16 | OPENXML flags parameter must be of data type int. |
| 7002 | 16 | OPENXML XPath must be of a string data type, such as nvarchar. |
| 7003 | 16 | Only one OPENXML column can be of type %ls. |
| 7004 | 16 | OPENXML does not support retrieving schema from remote tables, as in '%.*ls'. |
| 7005 | 16 | OPENXML requires a metaproperty namespace to be declared if 'mp' is used for another namespace in sp_xml_preparedocument. |
| 7006 | 16 | OPENXML encountered a problem identifying the metaproperty namespace prefix. Consider removing the namespace parameter from the corresponding sp_xml_preparedocument statement. |
| 7007 | 16 | OPENXML encountered unknown metaproperty '%.*ls'. |
| 7008 | 16 | The OPENXML EDGETABLE is incompatible with the XMLTEXT OVERFLOW flag. |
| 7009 | 16 | OPENXML allows only one metaproperty namespace prefix declaration in sp_xml_preparedocument. |
| 7101 | 16 | You cannot use a text pointer for a table with option 'text in row' set to ON. |
| 7102 | 20 | SQL Server Internal Error. Text manager cannot continue with current statement. |
| 7103 | 16 | You cannot set option 'text in row' for table %s. |
| 7104 | 16 | Offset or size type is invalid. Must be int or smallint data type. |
| 7105 | 22 | Page %S_PGID, slot %d for text, ntext, or image node does not exist. |
| 7106 | 16 | You cannot update a blob with a read-only text pointer |
| 7107 | 16 | You can have only 1,024 in-row text pointers in one transaction |
| 7116 | 16 | Offset %d is not in the range of available text, ntext, or image data. |
| 7122 | 16 | Invalid text, ntext, or image pointer type. Must be binary(16). |
| 7123 | 16 | Invalid text, ntext, or image pointer value %hs. |
| 7124 | 16 | The offset and length specified in the READTEXT statement is greater than the actual data length of %ld. |
| 7125 | 16 | The text, ntext, or image pointer value conflicts with the column name specified. |
| 7126 | 16 | The text, ntext, or image pointer value references a data page with an invalid text, ntext, or image status. |
| 7127 | 16 | The text, ntext, or image pointer value references a data page with an invalid timestamp. |
| 7128 | 16 | The text, ntext, or image pointer value references a data page that is no longer allocated. |
| 7130 | 16 | %ls WITH NO LOG is not valid at this time. Use sp_dboption to set the 'select into/bulkcopy' option on for database '%.*ls'. |
| 7133 | 16 | NULL textptr (text, ntext, or image pointer) passed to %ls function. |
| 7135 | 16 | Deletion length %ld is not in the range of available text, ntext, or image data. |
| 7137 | 16 | %s is not allowed because the column is being processed by a concurrent snapshot and is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS). |
| 7138 | 16 | The WRITETEXT statement is not allowed because the column is being replicated with Data Transformation Services (DTS). |
| 7139 | 16 | Length of text, ntext, or image data (%ld) to be replicated exceeds configured maximum %ld. |
| 7141 | 16 | Must create orphaned text inside a user transaction. |
| 7142 | 16 | Must drop orphaned text before committing the transaction. |
| 7143 | 16 | Invalid locator de-referenced. |
| 7201 | 17 | Could not execute procedure on remote server '%.*ls' because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access. |
| 7202 | 11 | Could not find server '%.*ls' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. |
| 7212 | 16 | Could not execute procedure '%.*ls' on remote server '%.*ls'. |
| 7213 | 20 | Could not set up parameter for remote server '%.*ls'. |
| 7214 | 16 | Remote procedure time out of %d seconds exceeded. Remote procedure '%.*ls' is canceled. |
| 7221 | 16 | Could not relay results of procedure '%.*ls' from remote server '%.*ls'. |
| 7300 | 16 | OLE DB error trace [%ls]. |
| 7301 | 16 | Could not obtain a required interface from OLE DB provider '%ls'. |
| 7302 | 16 | Could not create an instance of OLE DB provider '%ls'. |
| 7303 | 16 | Could not initialize data source object of OLE DB provider '%ls'. %ls |
| 7304 | 16 | Could not create a new session on OLE DB provider '%ls'. |
| 7305 | 16 | Could not create a statement object using OLE DB provider '%ls'. |
| 7306 | 16 | Could not open table '%ls' from OLE DB provider '%ls'. %ls |
| 7307 | 16 | Could not obtain the data source of a session from OLE DB provider '%ls'. This action must be supported by the provider. |
| 7310 | 16 | Could not obtain the schema options for OLE DB provider '%ls'. The provider supports the interface, but returns a failure code when it is used. |
| 7311 | 16 | Could not obtain the schema rowset for OLE DB provider '%ls'. The provider supports the interface, but returns a failure code when it is used. |
| 7312 | 16 | Invalid use of schema and/or catalog for OLE DB provider '%ls'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema. |
| 7313 | 16 | Invalid schema or catalog specified for provider '%ls'. |
| 7314 | 16 | OLE DB provider '%ls' does not contain table '%ls'. The table either does not exist or the current user does not have permissions on that table. |
| 7315 | 16 | OLE DB provider '%ls' contains multiple tables that match the name '%ls'. |
| 7316 | 16 | Could not use qualified table names (schema or catalog) with OLE DB provider '%ls' because it does not implement required functionality. |
| 7317 | 16 | OLE DB provider '%ls' returned an invalid schema definition. |
| 7318 | 16 | OLE DB provider '%ls' returned an invalid column definition. |
| 7319 | 16 | OLE DB provider '%ls' returned a '%ls' index '%ls' with incorrect bookmark ordinal %d. |
| 7320 | 16 | Could not execute query against OLE DB provider '%ls'. %ls |
| 7321 | 16 | An error occurred while preparing a query for execution against OLE DB provider '%ls'. %ls |
| 7322 | 16 | A failure occurred while giving parameter information to OLE DB provider '%ls'. %ls |
| 7323 | 16 | An error occurred while submitting the query text to OLE DB provider '%ls'. %ls |
| 7330 | 16 | Could not fetch a row from OLE DB provider '%ls'. %ls |
| 7331 | 16 | Rows from OLE DB provider '%ls' cannot be released. %ls |
| 7332 | 16 | Could not rescan the result set from OLE DB provider '%ls'. %ls |
| 7333 | 16 | Could not fetch a row using a bookmark from OLE DB provider '%ls'. %ls |
| 7340 | 16 | Could not create a column accessor for OLE DB provider '%ls'. %ls |
| 7341 | 16 | Could not get the current row value of column '%ls.%ls' from the OLE DB provider '%ls'. %ls |
| 7342 | 16 | Unexpected NULL value returned for column '%ls.%ls' from the OLE DB provider '%ls'. This column cannot be NULL. |
| 7343 | 16 | OLE DB provider '%ls' could not %ls table '%ls'. %ls |
| 7344 | 16 | OLE DB provider '%ls' could not %ls table '%ls' because of column '%ls'. %ls |
| 7345 | 16 | OLE DB provider '%ls' could not delete from table '%ls'. %ls |
| 7346 | 16 | Could not get the data of the row from the OLE DB provider '%ls'. %ls |
| 7347 | 16 | OLE DB provider '%ls' returned an unexpected data length for the fixed-length column '%ls.%ls'. The expected data length is %ls, while the returned data length is %ls. |
| 7348 | 16 | OLE DB provider '%ls' could not set range for table '%ls'.%ls |
| 7349 | 16 | OLE DB provider '%ls' could not set range for table '%ls' because of column '%ls'.%ls |
| 7350 | 16 | Could not get the column information from the OLE DB provider '%ls'. |
| 7351 | 16 | OLE DB provider '%ls' could not map ordinals for one or more columns of object '%ls'. |
| 7352 | 16 | OLE DB provider '%ls' supplied inconsistent metadata. The object '%ls' was missing expected column '%ls'. |
| 7353 | 16 | OLE DB provider '%ls' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time. |
| 7354 | 16 | OLE DB provider '%ls' supplied invalid metadata for column '%ls'. %ls |
| 7355 | 16 | OLE DB provider '%ls' supplied inconsistent metadata for a column. The name was changed at execution time. |
| 7356 | 16 | OLE DB provider '%ls' supplied inconsistent metadata for a column. Metadata information was changed at execution time. |
| 7357 | 16 | Could not process object '%ls'. The OLE DB provider '%ls' indicates that the object has no columns. |
| 7358 | 16 | Could not execute query. The OLE DB provider '%ls' did not provide an appropriate interface to access the text, ntext, or image column '%ls.%ls'. |
| 7359 | 16 | The OLE DB provider '%ls' reported a schema version for table '%ls' that changed between compilation and execution. |
| 7360 | 16 | Could not get the length of a storage object from the OLE DB provider '%ls' for table '%ls', column '%ls'. |
| 7361 | 16 | Could not read a storage object from the OLE DB provider '%ls', for table '%ls', column '%ls'. |
| 7362 | 16 | The OLE DB provider '%ls' reported different meta data at run time for table '%ls' column '%ls'. |
| 7365 | 16 | Could not obtain optional metadata columns of columns rowset from the OLE DB provider '%ls'. |
| 7366 | 16 | Could not obtain columns rowset from OLE DB provider '%ls'. The provider supports the interface, but returns a failure code when used. |
| 7367 | 16 | The OLE DB provider '%ls' supports column-level collation, but failed to provide metadata column '%ls' at run time. |
| 7368 | 16 | The OLE DB provider '%ls' supports column-level collation, but failed to provide collation data for column '%ls'. |
| 7369 | 16 | The OLE DB provider '%ls' provided invalid collation. %ls. |
| 7370 | 16 | One or more properties could not be set on the query for OLE DB provider '%ls'. %ls |
| 7371 | 16 | One or more properties could not be set on the table for OLE DB provider '%ls'. |
| 7372 | 16 | Cannot get properties from OLE DB provider '%ls'. |
| 7373 | 16 | Could not set the initialization properties for the OLE DB provider '%ls'. |
| 7374 | 16 | Could not set the session properties for the OLE DB provider '%ls'. |
| 7375 | 16 | Could not open index '%ls' on table '%ls' from OLE DB provider '%ls'. %ls |
| 7376 | 16 | Could not enforce the remote join hint for this query. |
| 7377 | 16 | Cannot specify an index or locking hint for a remote data source. |
| 7378 | 16 | The update/delete operation requires a unique key or a clustered index on the remote table. |
| 7379 | 16 | OLE DB provider '%ls' returned an unexpected '%ls' for the decimal/numeric column '%ls.%ls'. The expected data length is '%ls', while the returned data length is '%ls'. |
| 7390 | 16 | The requested operation could not be performed because the OLE DB provider '%ls' does not support the required transaction interface. |
| 7391 | 16 | The operation could not be performed because the OLE DB provider '%ls' was unable to begin a distributed transaction. |
| 7392 | 16 | Could not start a transaction for OLE DB provider '%ls'. |
| 7393 | 16 | OLE DB provider '%ls' reported an error aborting the current transaction. |
| 7394 | 16 | OLE DB provider '%ls' reported an error committing the current transaction. |
| 7395 | 16 | Unable to start a nested transaction for OLE DB provider '%ls'. A nested transaction was required because the XACT_ABORT option was set to OFF. |
| 7399 | 16 | OLE DB provider '%ls' reported an error. %ls |
| 7401 | 16 | Cannot create OLE DB provider enumeration object installed with SQL Server. Verify installation. |
| 7403 | 16 | Could not locate registry entry for OLE DB provider '%ls'. |
| 7404 | 16 | The server could not load DCOM. |
| 7405 | 16 | Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. |
| 7410 | 16 | Remote access not allowed for Windows NT user activated by SETUSER. |
| 7411 | 16 | Server '%.*ls' is not configured for %ls. |
| 7413 | 16 | Could not perform a Windows NT authenticated login because delegation is not available. |
| 7414 | 16 | Invalid number of parameters. Rowset '%ls' expects %d parameter(s). |
| 7415 | 16 | Ad hoc access to OLE DB provider '%ls' has been denied. You must access this provider through a linked server. |
| 7416 | 16 | Access to the remote server is denied because no login-mapping exists. |
| 7417 | 16 | GROUP BY ALL is not supported in queries that access remote tables if there is also a WHERE clause in the query. |
| 7418 | 16 | Text, image, or ntext column was too large to send to the remote data source due to the storage interface used by the provider. |
| 7419 | 16 | Lazy schema validation error. Linked server schema version has changed. Re-run the query. |
| 7601 | 16 | Cannot use a CONTAINS or FREETEXT predicate on %S_MSG '%.*ls' because it is not full-text indexed. |
| 7602 | 16 | The Full-Text Service (Microsoft Search) is not available. The system administrator must start this service. |
| 7603 | 15 | Syntax error in search condition, or empty or null search condition '%ls'. |
| 7604 | 17 | Full-text operation failed due to a time out. |
| 7605 | 17 | Full-text catalog '%ls' has been lost. Use sp_fulltext_catalog to rebuild and to repopulate this full-text catalog. |
| 7606 | 17 | Could not find full-text index for database ID %d, table ID %d. Use sp_fulltext_table to deactivate then activate this index. |
| 7607 | 17 | Search on full-text catalog '%ls' for database ID %d, table ID %d with search condition '%ls' failed with unknown result (%x). |
| 7608 | 17 | An unknown full-text failure (%x) occurred in function %hs on full-text catalog '%ls'. |
| 7609 | 17 | Full-Text Search is not installed, or a full-text component cannot be loaded. |
| 7610 | 16 | Access is denied to '%ls', or the path is invalid. Full-text search was not installed properly. |
| 7611 | 10 | Warning: Request to start a population in full-text catalog '%ls' ignored because a population is currently active for this full-text catalog. |
| 7612 | 16 | %d is not a valid value for full-text system resource usage. |
| 7613 | 16 | Cannot drop index '%.*ls' because it enforces the full-text key for table '%.*ls'. |
| 7614 | 16 | Cannot alter or drop column '%.*ls' because it is enabled for Full-Text Search. |
| 7615 | 16 | A CONTAINS or FREETEXT predicate can only operate on one table. Qualify the use of * with a table name. |
| 7616 | 16 | Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database. |
| 7617 | 16 | Query does not reference the full-text indexed table. |
| 7618 | 16 | %d is not a valid value for a full-text connection time out. |
| 7620 | 16 | Conversion to data type %ls failed for full-text search key value 0x%ls. |
| 7621 | 16 | Invalid use of full-text predicate in the HAVING clause. |
| 7622 | 17 | Full-text catalog '%ls' lacks sufficient disk space to complete this operation. |
| 7623 | 17 | Full-text query failed because full-text catalog '%ls' is not yet ready for queries. |
| 7624 | 17 | Full-text catalog '%ls' is in an unusable state. Drop and re-create this full-text catalog. |
| 7625 | 16 | Full-text table has more than one LCID among its full-text indexed columns. |
| 7626 | 15 | The top_n_by_rank argument ('%d') must be greater than zero. |
| 7627 | 16 | Full-text catalog in directory '%ls' for clustered server cannot be created. Only directories on a disk in the cluster group of the server can be used. |
| 7628 | 17 | Cannot copy Schema.txt to '%.*ls' because access is denied or the path is invalid. Full-text search was not installed properly. |
| 7629 | 17 | Cannot open or query registry key '%.*ls'. |
| 7630 | 15 | Syntax error occurred near '%.*ls' in search condition '%.*ls'. |
| 7631 | 15 | Syntax error occurred near '%.*ls'. Expected '%.*ls' in search condition '%.*ls'. |
| 7632 | 15 | The value of the Weight argument must be between 0.0 and 1.0. |
| 7633 | 15 | The syntax <content search condition> OR NOT <content boolean term> is not allowed. |
| 7634 | 17 | Stack overflow occurred in parsing search condition '%.*ls'. |
| 7635 | 16 | The Microsoft Search service cannot be administered under the present user account |
| 7636 | 10 | Warning: Request to start a full-text index population on table '%ls' is ignored because a population is currently active for this table. |
| 7637 | 16 | Value %d is not valid for full-text data time-out. |
| 7638 | 10 | Warning: Request to stop change tracking has deleted all changes tracked on table '%ls'. |
| 7639 | 16 | Cannot use a full-text predicate on %S_MSG '%.*ls' because it is not located on the local server. |
| 7640 | 10 | Warning: Request to stop tracking changes on table '%ls' will not stop population currently in progress on the table. |
| 7641 | 16 | Full-Text catalog '%ls' does not exist. |
| 7642 | 16 | A full-text catalog named '%ls' already exists in this database. |
| 7905 | 16 | The object specified is neither a table nor a constraint |
| 7908 | 10 | The table '%.*ls' was created with the NO_LOG option. |
| 7910 | 10 | Repair: Page %S_PGID has been allocated to object ID %d, index ID %d. |
| 7911 | 10 | Repair: Page %S_PGID has been deallocated from object ID %d, index ID %d. |
| 7912 | 10 | Repair: Extent %S_PGID has been allocated to object ID %d, index ID %d. |
| 7913 | 10 | Repair: Extent %S_PGID has been deallocated from object ID %d, index ID %d. |
| 7914 | 10 | Repair: %ls page at %S_PGID has been rebuilt. |
| 7915 | 10 | Repair: IAM chain for object ID %d, index ID %d, has been truncated before page %S_PGID and will be rebuilt. |
| 7916 | 10 | Repair: Deleted record for object ID %d, index ID %d, on page %S_PGID, slot %d. Indexes will be rebuilt. |
| 7917 | 10 | Repair: Converted forwarded record for object ID %d, index ID %d, at page %S_PGID, slot %d to a data row. |
| 7918 | 10 | Repair: Page %S_PGID next and %S_PGID previous pointers have been set to match each other in object ID %d, index ID %d. |
| 7919 | 16 | Repair statement not processed. Database needs to be in single user mode. |
| 7920 | 10 | Processed %ld entries in sysindexes for database ID %d. |
| 7923 | 10 | Table %.*ls Object ID %ld. |
| 7924 | 16 | Index ID %ld. FirstIAM %S_PGID. Root %S_PGID. Dpages %ld. |
| 7925 | 16 | Index ID %d. %ld pages used in %ld dedicated extents. |
| 7927 | 16 | Total number of extents is %ld. |
| 7932 | 16 | The indexes for '%.*ls' are already correct. They will not be rebuilt. |
| 7933 | 16 | One or more indexes contain errors. They will be rebuilt. |
| 7934 | 16 | The table '%.*ls' has no indexes. |
| 7935 | 16 | REINDEX received an exception. Statement terminated. |
| 7937 | 16 | The data in table '%.*ls' is possibly inconsistent. REINDEX terminated. Run DBCC CHECKTABLE and report errors to your system administrator. |
| 7939 | 16 | Cannot detach database '%.*ls' because it does not exist. |
| 7940 | 16 | System databases master, model, msdb, and tempdb cannot be detached. |
| 7941 | 10 | Trace option(s) not enabled for this connection. Use 'DBCC TRACEON()'. |
| 7942 | 10 | DBCC %ls scanning '%.*ls' table... |
| 7943 | 10 | Table: '%.*ls' (%d); index ID: %d, database ID: %d |
| 7944 | 10 | %ls level scan performed. |
| 7945 | 10 | - Pages Scanned................................: %lu |
| 7946 | 10 | - Extents Scanned..............................: %lu |
| 7947 | 10 | - Extent Switches..............................: %lu |
| 7948 | 10 | - Avg. Pages per Extent........................: %3.1f |
| 7949 | 10 | - Scan Density [Best Count:Actual Count].......: %4.2f%ls [%lu:%lu] |
| 7950 | 10 | - Logical Scan Fragmentation ..................: %4.2f%ls |
| 7951 | 10 | - Physical Scan Fragmentation .................: %4.2f%ls |
| 7952 | 10 | - Extent Scan Fragmentation ...................: %4.2f%ls |
| 7953 | 10 | - Avg. Bytes Free per Page.....................: %3.1f |
| 7954 | 10 | - Avg. Page Density (full).....................: %4.2f%ls |
| 7955 | 10 | Invalid SPID %d specified. |
| 7956 | 10 | Permission to execute DBCC %ls denied. |
| 7957 | 10 | Cannot display the specified SPID's buffer; in transition. |
| 7958 | 10 | The specified SPID does not process input/output data streams. |
| 7959 | 10 | The DBCC statement is not supported in this release. |
| 7961 | 16 | Object ID %d, index ID %d, page ID %S_PGID, row ID %d. Column '%.*ls' is a var column with a NULL value and non-zero data length. |
| 7962 | 16 | Upgrade requires SQL Server to be started in single user mode. Restart SQL Server with the -m flag. |
| 7963 | 16 | Upgrade encountered a fatal error. See the SQL Server errorlog for more information. |
| 7965 | 16 | Table error: Could not check object ID %d, index ID %d due to invalid allocation (IAM) page(s). |
| 7966 | 10 | Warning: NO_INDEX option of %ls being used. Checks on non-system indexes will be skipped. |
| 7968 | 10 | Transaction information for database '%.*ls'. |
| 7969 | 10 | No active open transactions. |
| 7970 | 10 | %hsOldest active transaction: |
| 7971 | 10 | SPID (server process ID) : %d |
| 7972 | 10 | UID (user ID) : %d |
| 7974 | 10 | Name : %.*ls |
| 7975 | 10 | LSN : (%d:%d:%d) |
| 7977 | 10 | Start time : %.*ls |
| 7979 | 10 | %hsReplicated Transaction Information: |
| 7980 | 10 | Oldest distributed LSN : (%d:%d:%d) |
| 7982 | 10 | Oldest non-distributed LSN : (%d:%d:%d) |
| 7983 | 14 | User '%.*ls' does not have permission to run DBCC %ls for database '%.*ls'. |
| 7984 | 16 | Invalid object name '%.*ls'. |
| 7985 | 16 | The object name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d. |
| 7986 | 16 | Warning: Pinning tables should be carefully considered. If a pinned table is larger, or grows larger, than the available data cache, the server may need to be restarted and the table unpinned. |
| 7991 | 16 | System table mismatch: Table '%.*ls', object ID %d has index ID 1 in sysindexes but the status in sysobjects does not have the clustered bit set. The table will be checked as a heap. |
| 7992 | 16 | Cannot shrink 'read only' database '%.*ls'. |
| 7993 | 10 | Cannot shrink file '%d' in database '%.*ls' to %d pages as it only contains %d pages. |
| 7994 | 16 | Object ID %d, index ID %d: FirstIAM field in sysindexes is %S_PGID. FirstIAM for statistics only and dummy index entries should be (0:0). |
| 7995 | 16 | Database '%ls' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further %ls processing. |
| 7996 | 16 | Extended stored procedures can only be created in the master database. |
| 7997 | 16 | '%.*ls' does not contain an identity column. |
| 7998 | 16 | Checking identity information: current identity value '%.*hs', current column value '%.*hs'. |
| 7999 | 16 | Could not find any index named '%.*ls' for table '%.*ls'. |