SQL Server Errors or Failures Error: 2567 to Error: 2590

SQLServerF1

 

Error: 2567, Severity: 14, DBCC INDEXDEFRAG cannot be used on system table indexes,
Error: 2568, Severity: 16, Page %S_PGID is out of range for this database or is in a log file.,
Error: 2570, Severity: 16, Page %S_PGID, slot %d in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type “%.*ls”). Column “%.*ls” value is out of range for data type “%.*ls”. Update column to a legal value.,
Error: 2571, Severity: 14, User ‘%.*ls’ does not have permission to run DBCC %.*ls.,

Error: 2572, Severity: 16, DBCC cannot free DLL ‘%.*ls’. The DLL is in use.,
Error: 2573, Severity: 16, Could not find table or object ID %.*ls. Check system catalog.,
Error: 2574, Severity: 16, Table error: Page %S_PGID is empty in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). This is not permitted at level %d of the B-tree.,
Error: 2575, Severity: 16, The Index Allocation Map (IAM) page %S_PGID is pointed to by the next pointer of IAM page %S_PGID in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), but it was not detected in the scan.,
Error: 2576, Severity: 16, The Index Allocation Map (IAM) page %S_PGID is pointed to by the previous pointer of IAM page %S_PGID in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), but it was not detected in the scan.,

Error: 2577, Severity: 16, Chain sequence numbers are out of order in the Index Allocation Map (IAM) chain for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). Page %S_PGID with sequence number %d points to page %S_PGID with sequence number %d.,
Error: 2579, Severity: 16, Table error: Extent %S_PGID in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) is beyond the range of this database.,
Error: 2580, Severity: 16, Table ‘%.*ls’ is either a system or temporary table. DBCC CLEANTABLE cannot be applied to a system or temporary table.,
Error: 2581, Severity: 10, DBCC cannot free the DLL “%.*ls”. The DLL is not loaded.,
Error: 2583, Severity: 16, An incorrect number of parameters was given to the DBCC statement.,
Error: 2585, Severity: 16, Cannot find partition number %ld for table “%.*ls”.,
Error: 2586, Severity: 16, Cannot find partition number %ld for index “%.*ls”, table “%.*ls”.,
Error: 2587, Severity: 16, The invalid partition number %ld was specified.,
Error: 2588, Severity: 16, Cannot find partition number %ld for index ID %d, object ID %d.,
Error: 2589, Severity: 16, Repair could not fix all errors on the first attempt.,
Error: 2590, Severity: 10, User “%.*ls” is modifying bytes %d to %d of page %S_PGID in database “%.*ls”.,

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *