• Nothing like stating the obvious. I had used the checkdb and it identified that the only object with a problem was the one table. so I thought I would just "fix" the one table. Although I have to say why will it let me run checkdb with repair but not checktable with repair?

    If I loose any data from this table it will be okay. It happens to have specific historical data from 2003 that I can restore from a development copy of this database.

    I'm running checkdb with repair while typing this reply.

    THANK YOU MUCH.