|
Home > Archive > MS SQL Server > March 2006 > DBCC CHECKDB Reporting Errors in - SQL Server 2005
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DBCC CHECKDB Reporting Errors in - SQL Server 2005
|
|
| Srikanth 2006-03-05, 8:24 pm |
| 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.
| |
| John Bell 2006-03-06, 7:23 am |
| Hi
You may want to check out:
http://msdn.microsoft.com/library/d...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, 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.
>
>
>
|
|
|
|
|