Yikes, are they storing War and Peace? If you can/want to break it out of the DB, write it to a file then store the file location in the DB. This would require an initial pass to write out the data already in there and some CF work to pull the data in a different way (files vs. DB), but it would work.
Mike -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 2:27 PM To: CF-Talk Subject: Maxewd out ntext in SQL Server. Now what? Sheesh - in a Newsletter system I've set up for a client, each separate story for the newsletter gets stored in a SQL Server "ntext" field. They just managed to MAX it out! A. I need Unicode. B. I need more storage than the ntext field is allowing C. Can't bust what's already there (over 100 newsletters with multiple stories each all stored in the ntext field) Suggestions? -- ----------- Les Mizzell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220597 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54