http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : SQL Exceeds 8060 Limit Sat, 11 Apr 2026 13:51:03 -700 Mon, 11 May 2009 20:14:44 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1252 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=1252&PID=4509#4509 Author: *Calsy
Subject: 1252
Posted: 11-May-2009 at 8:14pm

Hi All, I know this is not really an ideablade question but it works hand in hand with it. Our application connects to an sql server database (which is where ideablade steps in). The problem we have is that in SQL Server 2000 (which a percentage of our customers are still on and will never leave) we have the issue that a row cannot contain more than 8060k bytes. We have one table which has 3 fields which are nvarchar(2000) which has worked fine. We need to expand these fields to nvarchar(4000), which is where the problem comes in. If the user populates all 3 fields they get an error on save stating ....row cannot exceed the 8060 limit...... This only occurs in sql server 2000 because sql server 2005 and on caters for this. The options we have are setting the fields to be of datatype Text, but I am told this will cause performance issues or creating new tables which have a foreign key back to the main table to store the large text which will over complicate the database design.

Just wondering if anyone has come across this conundrum? And any advice on the problem would greatly appreciated.

Thanks
]]> Mon, 11 May 2009 20:14:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1252&PID=4509#4509