Error Msg

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

Muhammad Bilal (MuhammadBilal@discussions.microsoft.com) writes:
> 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.”

You have now posted the same question four times, despite that John Bell
answered already your first. Did you look at
http://support.microsoft.com/kb/892803/? Was it applicable?



--
Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx