Error 2510

Severity Level 16

Message Text

Table Corrupt: Keys do not match between leaf page %ld and data page %ld; check row # %d on the data page

Explanation

This error indicates that an index is not consistent with the table data that it represents.

Action

Use the following procedure:

  1. Record the leaf page number from the error text. To identify which table and index correspond to the leaf page number, see "Associating a Page with an Object" in Chapter 24, "Additional Problem-solving Techniques."
  2. Record the object ID and index ID.

    If the object with the error is not a system table (its object ID is 100 or greater), continue to the next step.

    If the object with the error is a system table (its object ID is less than 100), you cannot drop the index. Restore the database from a known clean backup.

  3. Find the name of the index involved, as follows:
    select name from sysindexes
    where indid = index_id
    and id = object_id
  4. Drop and re-create the index. (For information about using DROP INDEX and CREATE INDEX, see the Microsoft SQL Server Transact-SQL Reference.)
  5. Run DBCC CHECKTABLE and DBCC CHECKALLOC on the affected table to verify that all problems have been corrected at the table level.

If problems persist, contact your primary support provider. Have the output from the appropriate DBCC statements available for review.