December 10, 2008 at 8:49 am
I have recently upgraded from SQL Server 2000 to SQL Server 2005. I have one particular table which has 505 columns. This was working fine on SQL Server 2000, but after upgrade I get the "Cannot create a row of size 9510 which is greater than the allowable maximum of 8060." error message. I have removed a number of columns and the table is now good, we are down to 444 columns. I have read a number of posts on here explaining how SQL Server 2005 now works, with ROW_OVERFLOW etc. What I specifically would like to know is what changed so that what was allowed in SQL Server 2000 is not allowed in SQL Server 2005? Is it just that SQL Server 2005 has just become stricter in applying its rules?
I know this is a huge table and pretty unrealistic to keep it at that size, I am working on that. I would just like an explanation of why it used to work and now doesn't.
Be gentle with me I am a newbie to this forum.
December 10, 2008 at 9:42 am
That's strange. You should have had issues with this in 2000 as well.
I haven't specifically seen this, but I suspect that loopholes that might not have been well enforced in 2000, like adding columns, may be in 2005.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply