Prev: Why is "avacodo" not stemmed when using freetext or freetexttable
Next: Server: Msg 7105
From: Muhammad Bilal on 17 May 2010 09:32
Hi.
When I drop the table through query or enterprise manager in sql server 2000
it gives the following error

“Server: Msg 7105, Level 22, State 3, Line 1
Page (1:1424), slot 0 for text, ntext, or image node does not exist.
Connection Broken”

There is no column with the data type text, ntext or image is in table and
no foreign key only a composite primary key is on the table.

But data in the table can be modified, deleted or modified.

Dbcc checkdb also raises error

“Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 2655486279680 owned by data record
identified by RID = (1:377:11) id = 1142295129 and indid = 10.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1424),
slot 0, text ID 2655486279680 is referenced by page (1:1410), slot 7, but was
not seen in the scan.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:1427),
slot 2, text ID 2655486279680 is not referenced.”


Regards,
Muhammad Bilal
From: John Bell on 17 May 2010 10:02
On Mon, 17 May 2010 06:32:01 -0700, Muhammad Bilal
<MuhammadBilal(a)discussions.microsoft.com> wrote:

>Hi.
>When I drop the table through query or enterprise manager in sql server 2000
>it gives the following error
>
>�Server: Msg 7105, Level 22, State 3, Line 1
>Page (1:1424), slot 0 for text, ntext, or image node does not exist.
>Connection Broken�
>
>There is no column with the data type text, ntext or image is in table and
>no foreign key only a composite primary key is on the table.
>
>But data in the table can be modified, deleted or modified.
>
>Dbcc checkdb also raises error
>
>�Server: Msg 8929, Level 16, State 1, Line 1
>Object ID 2: Errors found in text ID 2655486279680 owned by data record
>identified by RID = (1:377:11) id = 1142295129 and indid = 10.
>Server: Msg 8965, Level 16, State 1, Line 1
>Table error: Object ID 2. The text, ntext, or image node at page (1:1424),
>slot 0, text ID 2655486279680 is referenced by page (1:1410), slot 7, but was
>not seen in the scan.
>Server: Msg 8964, Level 16, State 1, Line 1
>Table error: Object ID 2. The text, ntext, or image node at page (1:1427),
>slot 2, text ID 2655486279680 is not referenced.�
>
>
>Regards,
>Muhammad Bilal

Hi Muhammad

Have you looked at http://support.microsoft.com/kb/892803? it looks
like it could be related to shrinking the database and/or corruption
of sysindexes.

John

 | 
Pages: 1
Prev: Why is "avacodo" not stemmed when using freetext or freetexttable
Next: Server: Msg 7105