|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Error....Could not retrieve row from...
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 |
Error....Could not retrieve row from...
|
|
|
| Sql 6.5 sp5a, NT 4.0 sp4 ( i know vendor doesnt support any higher)
I got this message from the server.
DATE/TIME: 11/20/02/11:34:30 AM
DESCRIPTION: Error : 625, Severity: 20, State: 1
Could not retrieve row from logical page 511606 via RID because the entry in
the offset table (= 0) for that RID (= 2) is less than or equal to 0.
MESSAGE: (None)
TASK RUN: (None)
Nothing more in the NT event log
I ran dbcc checkdb (rx) on the database and did not get any errors. Is
there more I can try to validate the message?
Also how do you determine if the reference is a data page or index?
TIA
CD
| |
| Tibor Karaszi 2002-11-21, 6:23 am |
| I believe that there's a section in 6.5 Books Online on how you determine which table/index is
associated with this page. You might want to search KB as well.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"CD" <mcdye1@hotmail.com> wrote in message news:#ztbbcMkCHA.1428@tkmsftngp11...
> Sql 6.5 sp5a, NT 4.0 sp4 ( i know vendor doesnt support any higher)
>
> I got this message from the server.
> DATE/TIME: 11/20/02/11:34:30 AM
>
> DESCRIPTION: Error : 625, Severity: 20, State: 1
>
> Could not retrieve row from logical page 511606 via RID because the entry in
> the offset table (= 0) for that RID (= 2) is less than or equal to 0.
>
>
> MESSAGE: (None)
>
>
> TASK RUN: (None)
>
> Nothing more in the NT event log
>
> I ran dbcc checkdb (rx) on the database and did not get any errors. Is
> there more I can try to validate the message?
>
> Also how do you determine if the reference is a data page or index?
>
> TIA
>
> CD
>
>
|
|
|
|
|