HI,
I am getting this ttype of errors in SQL Server 2005, This table have xml
column.
Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, index
ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (type
LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512 is
not referenced. [SQLSTATE 42000]
Please give some help on this , what will be the route cause of this problem
?
how to resolve it.Hi
You may want to check out:
http://msdn.microsoft.com/library/d...serr_2_0prl.asp
You may also want to check that this has not been re-introduced
http://support.microsoft.com/defaul...kb;en-us;281287
Try dropping and re-creating the index. If the error persists then you
should log it with PSS.
John
"Srikanth" wrote:
> HI,
> I am getting this ttype of errors in SQL Server 2005, This table have xml
> column.
> Msg 8964, Sev 16, State 1, Line 1 : Table error: Object ID 304720138, inde
x
> ID 1, partition ID 72057594055557120, alloc unit ID 72057594058702848 (typ
e
> LOB data). The off-row data node at page (4:26), slot 0, text ID 19136512
is
> not referenced. [SQLSTATE 42000]
> Please give some help on this , what will be the route cause of this probl
em?
> how to resolve it.
>
>
Sunday, February 19, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment