A CHECKDB run reports corruption in sys.extended_index_1066482673_384000. What kind of index are represented by the name pattern sys.extended_index_...? The message is:

The spatial index, XML index or indexed view 'sys.extended_index_1066482673_384000' (object ID ...) does not contain all rows that the view definition produces. This does not necessarily represent an integrity issue with the data in this database. For more information about troubleshooting DBCC errors on spatial indexes, XML indexes, and indexed views, see SQL Server Books Online.

  • Do you use spatial indexes ? Possibly, you can drop and recreate the object and run checkdb.
    – Kin Shah
    Dec 23, 2015 at 20:08
  • Here, I'm not concerned with resolving the corruption. I want to understand what kinds of objects generate such names.
    – boot4life
    Dec 23, 2015 at 20:55

1 Answer 1


Extended Indexes are full text indexes, XML indexes, and Spatial indexes. Reason, the 3 types of indexes are better handled outside the B+ tree index.

I know you do not care to correct this but, did you recently upgrade? Try changing the compatibility level if it's not SQL Server 2014 and run CHECKDB again

You can identify the table object for the extended index error by using the below code. You may need to tweak the name in the where clause if I have it wrong.

FROM sys.internal_tables it
AND it.name = 'extended_index_1066482673_384000'

Hope this helps!

  • 1
    Compat level is already max. I will try to rebuild those indexes.
    – boot4life
    Dec 24, 2015 at 11:16
  • Hi @boot4life, did rebuilding the index fix your problem? Thanks! Dec 24, 2015 at 14:56
  • No, this is "unfixable" corruption. I still have this (dba.stackexchange.com/questions/124655/…) and another, similar EXTENDED_LOGICAL_CHECKS bug as of 12.0.4427.24.
    – boot4life
    Mar 13, 2017 at 17:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.