Skip Navigation Links
Home
User-Defined Functions
Tips & Tricks
SQL Server 2005
SQL Server 2008
FAQ
Forums
Practice Test
Bookstore
Home > Tips & Tricks > Error Messages 501 to 1000
SQL Server Error Messages - Errors 501 to 1000

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
502 16 The SQL Debugging Interface (SDI) requires that SQL Server, when started as a service, must not log on as System Account. Reset to log on as user account using Control Panel.
503 16 Unable to send symbol information to debugger on %ls for connection %d. Debugging disabled.
504 16 Unable to connect to debugger on %ls (Error = 0x%08x). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on %.*ls. Debugging disabled for connection %d.
505 16 Current user account was invoked with SETUSER. Changing databases is not allowed.
506 16 Invalid escape character '%.*ls' was specified in a LIKE predicate.
507 16 Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.
508 16 Unable to connect to debugger on %ls (Error = 0x%08x). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on %.*ls. Debugging disabled for connection %d.
509 11 User name '%.*ls' not found.
510 16 Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.
511 16 Cannot create a row of size %d which is greater than the allowable maximum of %d.
512 16 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
513 16 A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database '%.*ls', table '%.*ls', column '%.*ls'.
514 16 Unable to communicate with debugger on %ls (Error = 0x%08x). Debugging disabled for connection %d.
515 16 Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.
516 16 Attempt to initialize OLE library failed. Check for correct versions of OLE DLLs on this machine.
517 16 Adding a value to a '%ls' column caused overflow.
518 16 Cannot convert data type %ls to %ls.
520 16 SQL Server no longer supports version %d of the SQL Debugging Interface (SDI).
528 16 System error detected during attempt to use the 'upsleep' system function.
529 16 Explicit conversion from data type %ls to %ls is not allowed.
532 16 The timestamp (changed to %S_TS) shows that the row has been updated by another user.
535 16 Difference of two datetime columns caused overflow at runtime.
536 16 Invalid length parameter passed to the substring function.
538 16 Cannot find '%.*ls'. This language may have been dropped. Contact your system administrator.
542 16 An invalid datetime value was encountered. Value exceeds the year 9999.
544 16 Cannot insert explicit value for identity column in table '%.*ls' when IDENTITY_INSERT is set to OFF.
545 16 Explicit value must be specified for identity column in table '%.*ls' when IDENTITY_INSERT is set to ON.
547 16 INSERT statement conflicted with COLUMN FOREIGN KEY constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.
UPDATE statement conflicted with COLUMN REFERENCE constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.
DELETE statement conflicted with COLUMN REFERENCE constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.
548 16 The identity range managed by replication is full and must be updated by a replication agent. The %ls conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls. Sp_adjustpublisheridentityrange can be called to get a new identity range.
550 16 The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.
551 16 The checksum has changed to %d. This shows that the row has been updated by another user.
552 16 CryptoAPI function "%ls" failed. Error 0x%x: %ls
555 16 User-defined functions are not yet enabled.
556 16 INSERT EXEC failed because the stored procedure altered the schema of the target table.
557 16 Only functions and extended stored procedures can be executed from within a function.
558 16 Remote function calls are not allowed within a function.
561 16 Failed to access file '%.*ls'
562 16 Failed to access file '%.*ls'. Files can be accessed only through shares
563 14 The transaction for the INSERT EXEC statement has been rolled back. The INSERT EXEC operation will be terminated.
564 16 Attempted to create a record with a fixed length of '%d'. Maximum allowable fixed length is '%d'.
565 18 The server encountered a stack overflow during compile time.
566 21 Error writing audit trace. SQL Server is shutting down.
567 16 File '%.*ls' either does not exist or is not a recognizable trace file. Or there was an error opening the file.
568 16 Server encountered an error '%.*ls'.
601 12 Could not continue scan with NOLOCK due to data movement.
602 21 Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.
604 21 Could not find row in sysobjects for object ID %ld in database '%.*ls'. Run DBCC CHECKTABLE on sysobjects.
605 21 Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.
607 21 Insufficient room was allocated for search arguments in the session descriptor for object '%.*ls'. Only %d search arguments were anticipated.
615 21 Could not find database table ID %d, name '%.*ls'.
617 20 Descriptor for object ID %ld in database ID %d not found in the hash table during attempt to unhash it.
618 21 A varno of %d was passed to the opentable system function. The largest valid value is %d.
622 16 Filegroup '%.*ls' has no files assigned to it. Tables, indexes, and text, ntext, and image columns cannot be populated on this filegroup until a file is added.
623 21 Could not retrieve row from page by RID because logical page %S_PGID is not a data page. %S_RID. %S_PAGE.
624 21 Could not retrieve row from page by RID because the requested RID has a higher number than the last RID on the page. %S_RID.%S_PAGE, DBID %d.
625 21 Cannot retrieve row from page %S_PGID by RID because the slotid (%d) is not valid.
626 16 Cannot use ROLLBACK with a savepoint within a distributed transaction.
627 16 Cannot use SAVE TRANSACTION within a distributed transaction.
628 13 Cannot issue SAVE TRANSACTION when there is no active transaction.
635 20 Process %d tried to remove DES resource lock %S_DES, which it does not hold.
637 20 Index shrink program returned invalid status of 0.
639 21 Could not fetch logical page %S_PGID, database ID %d. The page is not currently allocated.
644 21 Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.
649 21 Could not find the clustered index entry for page %S_PGID, object ID %ld, status 0x%x. Index page %S_PGID, in database '%.*ls', was searched for this entry.
650 16 You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.
651 16 Cannot use %hs granularity hint on table '%.*ls' because locking at the specified granularity is inhibited.
652 16 Index ID %d for table '%.*ls' resides on a read-only filegroup which cannot be modified.
653 20 Two buffers are conflicting for the same keep slot in table '%.*ls'.
654 20 No slots are free to keep buffers for table '%.*ls'.
655 20 Expected to find buffer in keep slot for table '%.*ls'.
666 16 Maximum system-generated unique value for a duplicate group exceeded for table ID %d, index ID %d. Dropping and re-creating the index may fix the problem; otherwise use another clustering key.
667 16 Index %d for table '%.*ls' resides on offline filegroup that cannot be accessed.

Error Severity Description
701 19 There is insufficient system memory to run this query.
708 10 Warning: Due to low virtual memory, special reserved memory used %d times since startup. Increase virtual memory on server.
802 17 No more buffers can be stolen.
804 20 Could not find buffer 0x%lx holding logical page %S_PGID in the SDES 0x%lx kept buffer pool for object '%.*ls'.
809 20 Buffer 0x%lx, allocation page %S_PGID, in database '%.*ls' is not in allocation buffer pool in PSS (process status structure). Contact Technical Support.
813 20 Logical page %S_PGID in database ID %d is already hashed.
816 20 Process ID %d tried to remove a buffer resource lock %S_BUF that it does not hold in SDES %S_SDES. Contact Technical Support.
818 19 There is no room to hold the buffer resource lock %S_BUF in SDES %S_SDES. Contact Technical Support.
821 20 Could not unhash buffer at 0x%lx with a buffer page number of %S_PGID and database ID %d with HASHED status set. The buffer was not found. %S_PAGE.
822 21 Could not start I/O for request %S_BLKIOPTR.
823 24 I/O error %ls detected during %S_MSG at offset %#016I64x in file '%ls'.
834 21 The bufclean system function was called on dirty buffer (page %S_PGID, stat %#x/%#x, objid %#x, sstat%#x).
840 17 Device '%.*ls' (physical name '%.*ls', virtual device number %d) is not available. Contact the system administrator for assistance.
844 10 Time out occurred while waiting for buffer latch type %d, bp %#x, page %S_PGID, stat %#x, object ID %d:%d:%d, waittime %d. Continuing to wait.
845 17 Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.
901 21 Could not find descriptor for database ID %d, object ID %ld in hash table after hashing it.
902 16 To change the %ls, the database must be in state in which a checkpoint can be executed.
903 22 Could not find row in sysindexes for clustered index on system catalog %ld in database ID %d. This index should exist in all databases. Run DBCC CHECKTABLE on sysindexes in the database.
906 22 Could not locate row in sysobjects for system catalog '%.*ls' in database '%.*ls'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.
911 16 Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.
913 22 Could not find database ID %d. Database may not be activated yet or may be in transition.
916 14 Server user '%.*ls' is not a valid user in database '%.*ls'.
921 14 Database '%.*ls' has not been recovered yet. Wait and try again.
922 14 Database '%.*ls' is being recovered. Waiting until recovery is finished.
923 14 Database '%.*ls' is in restricted mode. Only the database owner and members of the dbcreator and sysadmin roles can access it.
924 14 Database '%.*ls' is already open and can only have one user at a time.
925 19 Maximum number of databases used for each query has been exceeded. The maximum allowed is %d.
926 14 Database '%.*ls' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
927 14 Database '%.*ls' cannot be opened. It is in the middle of a restore.
929 20 Attempting to close a database that is not already open. Contact Technical Support.
941 14 Cannot open database '%.*ls'. It has not been upgraded to the latest format.
942 14 Database '%.*ls' cannot be opened because it is offline.
943 14 Database '%.*ls' cannot be opened because its version (%d) is later than the current server version (%d).
944 10 Converting database '%.*ls' from version %d to the current version %d.
945 16 Database '%.*ls' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
946 14 Cannot open database '%.*ls' version %d. Upgrade the database to the latest version.
947 16 Error while closing database '%.*ls' cleanly.
948 14 Database '%.*ls' cannot be upgraded. Database is version %d and this server supports version %d.
949 16 tempdb is skipped. You cannot run a query that requires tempdb
950 14 Database '%.*ls' cannot be upgraded - database has a version (%d) earlier than SQL Server 7.0(%d).
951 10 Database '%.*ls' running the upgrade step from version %d to version %d.
952 16 Database '%.*ls' is in transition. Try the statement later.
953 16 Warning: Index '%ls' on '%ls' in database '%ls' may be corrupt because of expression evaluation changes in this release. Drop and re-create the index.

Related Articles :