SQL Server Helper - Error Message 7501 to 8000

Tip of the Day : SQL Server Database Design - Twitter Profile and Followers

Error Messages

Home > Tips & Tricks > Error Messages 7501 to 8000

SQL Server Error Messages - Errors 7501 to 8000

SQL Server Error Message - 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'.