• thanks for your swift response, I am placing some part of error, may be you will get any idea about this error and please help me to describe it or if any ways i can reoccur access related error.

    Table error: Object ID 802101898, index ID 1, partition ID 72057614975041536, alloc unit ID 72057594057457664 (type LOB data). The off-row data node at page (1:176), slot 0, text ID 1108672512 is referenced by page (1:61599228), slot 18, but was not seen in the scan.

    Msg 8965, Level 16, State 1, Line 1

    Table error: Object ID 802101898, index ID 1, partition ID 72057614975041536, alloc unit ID 72057594057457664 (type LOB data). The off-row data node at page (1:176), slot 1, text ID 1936326656 is referenced by page (1:61619151), slot 2, but was not seen in the scan.

    Msg 8965, Level 16, State 1, Line 1

    Table error: Object ID 802101898, index ID 1, partition ID 72057614975041536, alloc unit ID 72057594057457664 (type LOB data). The off-row data node at page (1:176), slot 2, text ID 1735917568 is referenced by page (1:61600768), slot 36, but was not seen in the scan.

    Msg 8965, Level 16, State 1, Line 1

    Table error: Object ID 802101898, index ID 1, partition ID 72057614975041536, alloc unit ID 72057594057457664 (type LOB data). The off-row data node at page (1:176), slot 3, text ID 2062155776 is referenced by page (1:61603772), slot 15, but was not seen in the scan.

    Msg 8965, Level 16, State 1, Line 1

    Table error: Object ID 802101898, index ID 1, partition ID 72057614975041536, alloc unit ID 72057594057457664 (type LOB data). The off-row data node at page (1:176), slot 4, text ID 1254359040 is referenced by page (1:61602084), slot 28, but was not seen in the scan.

    Msg 8965, Level 16, State 1, Line 1

    Table error: Object ID 802101898, index ID 1, partition ID 72057614975041536, alloc unit ID 72057594057457664 (type LOB data). The off-row data node at page (1:176), slot 5, text ID 1994981376 is referenced by page (1:61602324), slot 4, but was not seen in the scan.

    Msg 8965, Level 16, State 1, Line 1

    Table error: Object ID 802101898, index ID 1, partition ID 72057614975041536, alloc unit ID 72057594057457664 (type LOB data). The off-row data node at page (1:176), slot 6, text ID 670629888 is referenced by page (1:61612751), slot 7, but was not seen in the scan.

    Msg 8965, Level 16, State 1, Line 1