Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kanasai
Starting Member
3 Posts |
 Posted - 2003-05-08 : 09:44:26
|
| hi,whenever i want to add a new field or export the table to another database the following message appears:Cannot create a row of size 8064 which is greater than the allowable maximum of 8060.I could export the table if I delete some fields. I couldn't figure out what is going wrong. There is a nvarchar(8000) field in the table, could it be the problem?Can I substitute nvarchar(8000) with (ntext16)? What are their differences? This field is supposed to store a huge text message. What is the best datatype to use for this purpose?Please excuse me for the dump question because i am new. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-08 : 10:30:44
|
| Max row size is 8060 so if you want something larger than this you will have to do something.nvarchchar(8000) is invalid. varchar(8000) or nvarchar(4000).You can create a new table for this field and link to it with the primary key. You can create several records like this with a sequence number for and size text.Text fields do not allow some operatations and are more involved to update. Have a look in bol.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
kanasai
Starting Member
3 Posts |
Posted - 2003-05-08 : 23:00:53
|
| i have the same database with the same datatype and data in my local PC, i can export the table to another DB locally without any error. This error only happen when i transfer from the remote server to my local PC.Why is this? |
|
|
|
|
|
|
Add new field and export error