March 23, 2006 at 9:57 am
I have a weird issue.
Here are the stmts that I have run in order.
dbcc checktable table1 - no errors
alter table table1 add version varchars(15) null; - no errors
update table1 set version = '1.0.0.1'; - no errors
dbcc checktable table1 - ERRORS
ERRORS:
Msg 2537, Level 16, State 24, Line 1
Table error: object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 49193006989312 (type In-row data), page (1:237), row 0. The record check (valid record length) failed. The values are 271 and 267.
Msg 8929, Level 16, State 1, Line 1
Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 49193006989312 (type In-row data): Errors found in off-row data with ID 53411840 owned by data record identified by RID = (1:237:0)
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 0, text ID 53411840 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 1, text ID 53477376 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 2, text ID 53542912 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 3, text ID 53608448 is not referenced.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 750625717, index ID 0, partition ID 49193006989312, alloc unit ID 71825312068206592 (type LOB data). The off-row data node at page (1:343), slot 4, text ID 53673984 is not referenced.
There are 1 rows in 1 pages for object "TABLE1".
I found these two KBs on MS's website:
http://support.microsoft.com/kb/832437/en-us
http://support.microsoft.com/kb/872842/en-us
Another oddity with this is that I can add the column and run the update stmt to another table, and there is no error.
I was able to correct this by doing a dbcc checktable (table1, REPAIR_ALLOW_DATA_LOSS).
Any ideas why this could be happening?
Thanks,
Matt
March 27, 2006 at 8:00 am
This was removed by the editor as SPAM
July 6, 2010 at 8:01 am
Fixed the same issue by rebuilding indexes.
DBCC DropCleanBuffers
go
DBCC FreeProcCache
go
DBCC DropCleanBuffers
go
exec sp_updatestats
go
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
July 7, 2010 at 1:45 am
Hi ,
The KB articles are referring to SQL 2000. Please post the full build number for your SQL Server 2005.
It is difficult to answer without a close look at the table and pages structures. Could you post the DDL of the table so we can try to reproduce the problem, plus the following:
[font="Courier New"]
dbcc ind('<base>','table1',-1)
dbcc traceon(3604)
dbcc page(<dbid>,1,237,3)
dbcc page(<dbid>,1,343,3)[/font]
in attached files ?
Thx,
David B.
David B.
July 7, 2010 at 6:29 am
Forget it, I didn't see the timestamp in the main post :-D. I guess the pages are long gone now...
David B.
David B.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply