View Single Post
  #4 (permalink)  
Old March 23rd, 2009, 09:49 AM
philip_cole philip_cole is offline
Friend of Wrox
Points: 894, Level: 11
Points: 894, Level: 11 Points: 894, Level: 11 Points: 894, Level: 11
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: London, , United Kingdom.
Posts: 166
Thanks: 2
Thanked 33 Times in 33 Posts
Default

The only way you can really store more than 8060 bytes in a row in a single table is to make the columns TEXT, NTEXT or IMAGE. SQL 2000 stores these separate to the main row data, and can be up to 2GB in length. See http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx and http://msdn.microsoft.com/en-us/libr...3(SQL.80).aspx
TEXT datatypes are comparatively inefficient tho, so if you could find a way to reduce the field lengths or splitting it up somehow, that may be better.

HTH
Phil