• Do you have a backup? Have you tried the REPIAR_ALLOW_DATA_LOSS option with DBCC CHECKTABLE? If you have a current backup, I would restore the database to a NEW db, then run DBCC CHECKTABLE with REPIAR_ALLOW_DATA_LOSS on the corrupted table, and compare the old and new tables to see if anything is missing. Chances are that DBCC CHECKTABLE with REPIAR_ALLOW_DATA_LOSS will fix the issue without causing any data loss.

    _________________________________
    seth delconte
    http://sqlkeys.com