Home Forums SQL Server 2005 Data Corruption Corrupt Database running dbcc checkdb, missing sys.indexes (urgent help needed!) RE: Corrupt Database running dbcc checkdb, missing sys.indexes (urgent help needed!)

  • Holger, does this query return anything? If so, try a drop statistics with the name returned and see if that fixes the problem. Absolutely no promises.

    select object_name(object_id), name, stats_id from sys.stats where object_id = 1379588053 and stats_id = 3

    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