• Fixed, no. Deallocated the corrupt page, yes.

    CheckDB only checks allocated pages. If an index rebuild deallocated a corrupt page as part of the rebuild, the corruption would 'vanish', because it's no longer part of the allocated set of pages

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass