July 11, 2011 at 2:02 pm
I have a database which has two varchar(max) fields to hold longer text blocks. I know this is working for rows greater than page size, because I have some of them with up to 28K in them - well over the 8060 size limit.
I recently added a varchar(5) field on the end. I tried to do something like this:
Update mytable set newfield = 'ABC'
For every single record except 1, this works - it works on the shorter rows, it works on the longer rows. I have exactly 1 row that refuses to update.
This is the error message I get on that one row -
Msg 511, Level 16, State 1, Line 9
Cannot create a row of size 8066 which is greater than the allowable maximum of 8060.
Any ideas why just one row out of 345 thousand would fail to update?
Just to add to my confusion, I checked, and there was some blank space at the end of that text field - I removed about 20 characters, tried again, and I get an identical error message.
Any ideas why I cannot change this one row?
July 11, 2011 at 2:15 pm
Can you post the table DDL and the row in question along with the exact update statement? We can't really try to help without seeing exactly what you see...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply