There is an article on my web site that discusses corrupt data. You may find a solution there.
>Hi All,
>
>The indexes of databases go broken (so some records disappeared form table) in a networked system when a node using the software hangs or shuts down improperly. I have to Reindex all the tables of database or validate the databases to recover the index and lost data.
>
>Please help me to find any way to retain the indexes when a computer hangs.
>
>Yours
>
>Raoshan
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer