select cast(0x000E000000B80B0000 as decimal(14, 0)) correct, cast(0x000E000200B80B0000 as decimal(14, 0)) corruptedSee that deuce in the 4th byte reading from left to right? Looks weird because it should be 00 not 02 there, but runs correctly, i.e.
correct corrupted -------- ---------- -3000 -3000I am sure that the problem is caused by the original conversion from Allbase. I am glad that the data would be safe and pure in the end :)
No one has followed this question yet.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
DBCC ShrinkFile - better to do lots of little shrinks, or one big shrink?
What happens when you restore a SQL Server 2005 database ?
An inconsistency was detected during an internal operation in database