September 15, 2008 at 9:59 am
I need some help! 😀
I was running a search program I wrote and I got this message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a row of size 8178, which is greater than the allowable maximum of 8094.
I looked on MSDN (http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx) and I was wondering if this is a default value that could be changed to compensate for the extra length?
September 15, 2008 at 10:04 am
You can store data in a text/image column, but the max row size outside of that is fixed.
September 15, 2008 at 2:55 pm
It's a size of 1 page (8k) minus size of row overheads.
Size of pages used by SQL Server cannot be changed.
_____________
Code for TallyGenerator
September 15, 2008 at 3:25 pm
Thank you so much! Saved me a lot of time!:D
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply