View Single Post
  #2 (permalink)  
Old March 23rd, 2009, 08:20 AM
Jeff Moden Jeff Moden is offline
Friend of Wrox
Points: 1,536, Level: 15
Points: 1,536, Level: 15 Points: 1,536, Level: 15 Points: 1,536, Level: 15
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2006
Location: , MI, USA.
Posts: 475
Thanks: 0
Thanked 9 Times in 9 Posts
Default

Quote:
Originally Posted by juanita View Post
Hi,



I have a table with columns nvarchar 4000 characters each, and gives me error if you attempt to enter more than 8060 byte in a row. How can I extend the size of the row? Any way to do this?
No... not in the same table in SQL Server 2000. You have to make some "sister" tables with the same PK.

Why do you need so many columns to contain NVarchar 4000?
__________________
--Jeff Moden