| 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 |
The current user account was invoked with
SETUSER or SP_SETAPPROLE. Changing databases is not allowed. |
| 506 |
16 |
The invalid escape character "%.*ls" was
specified in a %ls 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). |
| 522 |
16 |
The WAITFOR thread was evicted. |
| 523 |
16 |
A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active. |
| 524 |
16 |
A trigger returned a resultset and the server option 'disallow results from triggers' is true. |
| 525 |
16 |
The column that was returned from the nodes() method cannot be converted to the data type %ls. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks. |
| 526 |
16 |
%ls of XML types constrained by different XML schema collections and/or DOCUMENT/CONTENT option is not allowed. Use the CONVERT function to run this query. |
| 527 |
16 |
Implicit conversion between XML types constrained by different XML schema collections is not allowed. Use the CONVERT function to run this query. |
| 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. |
| 530 |
16 |
The statement terminated. The maximum recursion %d has been exhausted before statement completion. |
| 531 |
10 |
Cannot set NOCOUNT to OFF inside the trigger execution because the server option "disallow_results_from_triggers" is true or we are inside LOGON trigger execution. |
| 532 |
16 |
The timestamp (changed to %S_TS) shows that the row has been updated by another user. |
| 533 |
10 |
Cannot set XACT ABORT to OFF inside the trigger execution unless the database compatibility is 90. |
| 534 |
16 |
'%.*ls' failed because it is not supported in the edition of this SQL Server instance '%.*ls'. See books online for more details on feature support in different SQL Server editions. |
| 535 |
16 |
Difference of two datetime columns caused overflow at runtime.
The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
|
| 536 |
16 |
Invalid length parameter passed to the substring function. |
| 537 |
16 |
Invalid length parameter passed to the LEFT or SUBSTRING function. |
| 538 |
16 |
Cannot find '%.*ls'. This language may have been dropped. Contact your system administrator. |
| 539 |
16 |
Schema changed after the target table was created. Rerun the Select Into query. |
| 540 |
16 |
There is insufficient system memory to run RAISERROR. |
| 541 |
16 |
There is not enough stack to execute the statement |
| 542 |
16 |
An invalid datetime value was encountered. Value exceeds the year 9999. |
| 543 |
16 |
Creation of a return table failed for the table valued function '%.*ls'. |
| 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. |
| 549 |
16 |
The collation '%.*ls' of receiving variable is not equal to the collation '%.*ls' of column '%.*ls'. |
| 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'. |
| 569 |
16 |
The handle that was passed to %ls was invalid. |
| 570 |
15 |
INSTEAD OF triggers do not support direct recursion. The trigger execution failed. |
| 571 |
16 |
The specified attribute value for %ls is invalid. |
| 572 |
16 |
Invalid regular expression "%.*ls" near the offset %d. |
| 573 |
16 |
Evaluation of the regular expression is too complex: '%.*ls'. |
| 574 |
16 |
%ls statement cannot be used inside a user transaction. |
| 575 |
16 |
A LOGON trigger returned a resultset. Modify the LOGON trigger to not return resultsets. |
| 576 |
16 |
Cannot create a row that has sparse data of size %d which is greater than the allowable maximum sparse data size of %d. |
| 577 |
16 |
The value provided for the timeout is not valid. Timeout must be a valid integer between 0 and 2147483647. |
| 578 |
16 |
Insert Exec not allowed in WAITFOR queries. |
| 579 |
16 |
Can not execute WAITFOR query with snapshot isolation level. |
| 582 |
16 |
Offset is greater than the length of the column to be updated in write. |
| 583 |
16 |
Negative offset or length in write. |
| 584 |
16 |
Select Into not allowed in WAITFOR queries. |
| 585 |
16 |
Changing database context is not allowed when populating the resource database. |
| 587 |
16 |
An invalid delayed CLR type fetch token is provided. |
| 588 |
16 |
Multiple tasks within the session are using the same delayed CLR type fetch token at the same time. |
| 589 |
16 |
This statement has attempted to access data whose access is restricted by the assembly. |
| 590 |
16 |
RPC was aborted without execution. |
| 591 |
16 |
%ls: The formal parameter "%ls" was defined as OUTPUT, but the actual parameter was not declared as OUTPUT. |
| 592 |
16 |
Cannot find %S_MSG ID %d in database ID %d. |
| 593 |
10 |
fn_trace_gettable: XML conversion of trace data for event 165 failed. |
| 594 |
10 |
fn_trace_gettable: XML conversion of trace data is not supported in fiber mode. |
| 595 |
16 |
Bulk Insert with another outstanding result set should be run with XACT_ABORT on. |
| 596 |
16 |
Cannot continue the execution because the session is in the kill state. |
| 597 |
16 |
The execution of in-proc data access is being terminated due to errors in the User Datagram Protocol (UDP). |
| 598 |
16 |
An error occurred while executing CREATE/ALTER DB. Please look at the previous error for more information. |
| 599 |
16 |
%.*ls: The length of the result exceeds the length limit (2GB) of the target large type. |
| 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. |
| 603 |
21 |
Could not find an entry for table or index with object ID %d (partition ID %I64d) in database %d. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHE |
| 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'. |
| 606 |
21 |
Metadata inconsistency. Filegroup id %ld specified for table '%.*ls' does not exist. Run DBCC CHECKDB or CHECKCATALOG. |
| 607 |
21 |
Insufficient room was allocated for search arguments in the session descriptor for object '%.*ls'. Only %d search arguments were anticipated. |
| 608 |
16 |
No catalog entry found for partition ID %I64d in database %d. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption. |
| 609 |
16 |
BTree is not empty when waking up on RowsetBulk. |
| 610 |
16 |
Invalid header value from a page. Run DBCC CHECKDB to check for a data corruption. |
| 611 |
16 |
Cannot insert or update a row because total variable column size, including overhead, is %d bytes more than the limit. |
| 613 |
21 |
Could not find an entry for worktable rowset with partition ID %I64d in database %d. |
| 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'. |
| 656 |
10 |
The partitioning function '%.*ls' creates %d partitions, which prevents removal of increased partitions support. |
| 657 |
16 |
Could not disable support for increased partitions in database '%.*ls' because %S_MSG. |
| 658 |
16 |
Could not enable support for increased partitions in database '%.*ls' because %S_MSG. |
| 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. |
| 669 |
22 |
The row object is inconsistent. Please rerun the query. |
| 670 |
16 |
Large object (LOB) data for table "%.*ls" resides on an offline filegroup ("%.*ls") that cannot be accessed. |
| 671 |
16 |
Large object (LOB) data for table "%.*ls" resides on a read-only filegroup ("%.*ls"), which cannot be modified. |
| 672 |
10 |
Failed to queue cleanup packets for orphaned rowsets in database "%.*ls". Some disk space may be wasted. Cleanup will be attempted again on database restart. |
| 674 |
10 |
Exception occurred in destructor of RowsetNewSS 0x%p. This error may indicate a problem related to releasing pre-allocated disk blocks used during bulk-insert operations. Restart the server to resolve this problem. |
| 675 |
10 |
Worktable with partition ID %I64d was dropped successfully after repeated attempts. |
| 676 |
10 |
Error occurred while attempting to drop worktable with partition ID %I64d. |
| 677 |
10 |
Unable to drop worktable with partition ID %I64d after repeated attempts. Worktable is marked for deferred drop. This is an informational message only. No user action is required. |
| 678 |
10 |
Active rowset for partition ID %I64d found at the end of the batch. This error may indicate incorrect exception handling. Use the current activity window in SQL Server Management Studio or the Transact-SQL KILL statement to terminate the server process id |
| 679 |
16 |
One of the partitions of index '%.*ls' for table '%.*ls'(partition ID %I64d) resides on a filegroup ("%.*ls") that cannot be accessed because it is offline, restoring, or defunct. This may limit the query result. |
| 680 |
10 |
Error [%d, %d, %d] occurred while attempting to drop allocation unit ID %I64d belonging to worktable with partition ID %I64d. |
| 681 |
16 |
Attempting to set a non-NULL-able column's value to NULL. |
| 682 |
16 |
Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption. |
| 683 |
22 |
An internal error occurred while trying to convert between variable-length and fixed-length decimal formats. Run DBCC CHECKDB to check for any database corruption. |
| 684 |
22 |
An internal error occurred while attempting to convert between compressed and uncompressed storage formats. Run DBCC CHECKDB to check for any corruption. |
| 685 |
22 |
An internal error occurred while attempting to retrieve a backpointer for a heap forwarded record. |