• run the dbcc checktable with repair and rebuild option and with error msg.

    this can done the page repare in database.

    this will retrive all the data without data loss. i get exact output.

    in case you are not identifiable the exact table run dbcc checkdb.