February 5, 2002 at 11:45 am
We just ported a web admin app from SQL 7/IIS 4 to SQL 2000/IIS 5.
There is one table maintained that has 3 varchar 8000 fields (plus an id and name field). One the new servers you can only enter ~1000 characters into any of the large fields. Even if the other 2 field are empty, the remaining field still will not allow more characters. I have stripped all CR and TAB chars, there is only chars and spaces.
This all worked fine on the old servers.
Has anyone come across this?
TIA
September
February 5, 2002 at 12:35 pm
Try setting your compatibility level back to 70 to see if that makes a difference.
Andy
February 5, 2002 at 1:50 pm
I had to make the 3 fields total less than 8000 - it must be some row limitations coming into play
February 6, 2002 at 2:32 pm
Is the error coming from SQL or IIS? When does it error out?
February 18, 2002 at 12:06 pm
We just had a similar issue and changed to text, which seems to work fine.
February 18, 2002 at 12:08 pm
It is always nice to know when someone else has a similar problem (not just me drinking too much coffee!).
Text wasn't an option for us, but making the individual field length so that the row length couldn't exceed 8000 seemed to do the trick.
Thanks
September
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply