Hi All - Thanks for your feedback. I ended up creating a table for over 2 billlion rows and preformed a number of updates on it. (I thought...

Thanks for this but I don't have much data in my test db.

Hi - Thanks for your input.

I have found the reason why this keeps happening - My query drops the column before populating it. I have had to...

V. strange. I have tried changing the field lengths from 320 to MAX (is this what you mean by changing the table options?), this fixed the problem but I'm...

Apologise to keep this going but I was wondering why SQL qould not more the MAX field (the field that i'm updating) onto a separate page? Thanks All!!

I agree. The database isn't designed with best practice in mind but we have plans in place to rename the objects.

Thanks for all the feedback guys. Much appreciated.

Thanks for this, it works!!

Do you know the technical reason behind it working with MAX and not 320? Thanks again, much appreciated.

I appreciate what you're saying but there seems to be no discrepancy with the record that is failing versus the records that update successfully.

Literally, I am updating thousands...

Hi there - I am at a loose end with this one!

I am inserting a value which contains approx. 2000 characters and it fails however the current datalength...

if I changed the out-of-row exception would be able to increase the number of characters; i.e

EXEC sp_tableoption 'demo.OneColVarcharMaxOut', 'large value types out of row', 1;

Ok, thanks.

OK, thanks for the advice. Are we saying that without making significant structural changes to the table I won't be able tot increase the number of characters in the...

Thanks but I can't change what is already there. I can update the field I have referenced but a structural change would take too long to get deployed to...

I can now access the link. Thanks for updating it. I'm having a look now.

The full DDL script is attached.

Thanks for your response. I don't think the link works, can you re-port. Thanks!