Prev: Server: Msg 7105
Next: sql200 SQLSERVERAGENT service won't start
From: Muhammad Bilal on 17 May 2010 11:16
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
 | 
Pages: 1
Prev: Server: Msg 7105
Next: sql200 SQLSERVERAGENT service won't start