hi, Thanks for your reply and steps for sorted out. there is only one record was loss.

I am using DBCC CHECKTABLE ('Table_name', REPAIR_ALLOW_DATA_LOSS)

thanks

ananda