Vlad Khorsun added a comment - 07/May/07 05:25 AM I see blob_id 0:0 in record. Also i see that NULL flag is not set for this field.
The only reason i can imagine for this is as follow:
user have nullable field initially, insert record with NULL blob, set NOT NULL flag manually and updated record leaving NULL in blob
This just a guess as i saw 'corrupted' db only (not talking with user about it) and real case was a bit complex ;)

Martijn Tonies added a comment - 08/May/07 03:50 AM Ah, so you mean that on the data page, for the field value, the NULL flag is not set, while it is set in the metadata ( by using a direct system table update? )

Vlad Khorsun added a comment - 08/May/07 04:37 AM Yes.
And i wrong that it can be done only by direct modifications in system tables ;)
We can add NOT NULL constraint via DDL of course.
We can't drop this constraint but this is another story ;)

Pavel Cisar added a comment - 24/Jul/07 08:03 AM As there is no clear and definitive test case (so the test was not created), I can only judge by changes made to the source, and it appears ok for both branches.