Skip Navigation Links
SQL Server 2012
SQL Server 2014
SQL Server 2016
Practice Test
Tip of the Day : How to Read and Load an Excel 2007 or Excel 2010 File Without Using Import/Export Utility
Error Messages
Home > Tips & Tricks > Error Messages 7501 to 8000
SQL Server Error Messages - Errors 7501 to 8000

A message number uniquely identifies each error message and the error message text describes the problem.  The error message text often includes placeholders for information (such as object names) to be inserted in the error message when it is displayed.  Unfortunately, the error message text does not tell you how to solve or work around the problem.  In this series of Error Messages list, we will try to provide you with ways on how to overcome or work around certain error messages.

Some error messages are self-explanatory and can easily be fixed, such as "Invalid object name".  Others are harder to fix or work around, especially by those who are new to SQL Server.  It is the intent of this page and succeeding pages (to come) to assist you in addressing or working around SQL Server error messages.

Error Severity Description
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.

Error Severity Description
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.
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'.

Related Articles :