Server: Msg 7105

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

On Mon, 17 May 2010 06:32:01 -0700, Muhammad Bilal
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