• DBANewbie (2/11/2016)


    Thanks very much. Could we try rebuilding those indexes or would any corruption on the data prevent the index from rebuilding?

    as Gail said, drop the indexes, run DBCC CHECKTABLE on the two tables.

    If theyre clean, create the indexes you dropped

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉