Multiple text fields per table

[redlam]

Other than the typical limitations of text datatypes, does anyone know of other potential issues when using multiple text fields in a single table? I need to convert a foxpro database to SQL2000 - many of the tables have multiple 'notes' fields. While varchar(8000) would probably meet the requirement for each 'notes' field - the table would then exceed SQL's record size limitation of 8060 bytes.
Suggestions, comments.... ?

 

[Qaroven]

Does each field have to be so large?
You could break it up into separate tables for the extra huge text fields .. just link them with original table's pri key Ben
+61 403 395 052

 

[redlam]

Unfortunately, they do have to be so huge. Some of the fields are long descriptions (one or two pages).
I thought about breaking up the tables as well - just trying to decide which option is the lessor of 2 evils. The notes fields are never searched, just displayed, so if there aren't any obvious problems with using multiple text fields I'd rather stick with a one table solution.
Thanks for your input!