• Ellen-477471 (7/8/2010)


    Although I have to say why will it let me run checkdb with repair but not checktable with repair?

    Because SQL knows that the database is damaged and needs repairing before it can be brought online. You may know that there's only one table, but the SQL repair and consistency requires that the entire database be repaired and all damage repaired before bringing the DB online.

    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