I am pretty sure that SQL Server has a maximum size for each row.   The only work aroudn would be changing the field do clob, because then that limit does not apply.

-----Original Message-----
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:57 AM
To: CF-Talk
Subject: OT:sql Row Error Msg?

Ok this is a new one for me!  I have a table that users add plans to.
Because each section of the plan can be extensive each field is 4000
characters long.
I have one user who is having a problem.  He said when he went to edit the
last field e received the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size
8063 which is greater than the allowable maximum of 8060.

So this has to actually do with a SQL row character maximum?  (Its' SQL2000)
I retried entering the plan in the test environment and had the same issue.
I then tried to do an edit from sql query analyzer and got the same message.
Anyone know about this- how to work around it?
Thanks,
J
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to