by Guy Havard » Tue, 26 Dec 2000 19:50:10
What can I do???
guy.
by BP Margoli » Wed, 27 Dec 2000 02:06:08
Sorry, but the maximum number of bytes per row is non-configurable.
Your best option **probably** is:
Break the table into two, in a one-to-one relationship ... you might even
have some performance gains by doing this, if you relegate not frequently
accessed columns to the new table.
There are one or two options also (there's usually more than one way to skin
a cat), but this would definitely be my first suggestion.
----------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:> Hi all,
> Is it possible to enlarge the total row size?
> I get an error that says: "The total row size (14908) for table 'book'
> exceeds the maximum number of bytes per row (8060)."
> It is immpossible for me to cut this number down as this is an Sybase
> database that I'm transferring to MS-SQL Server.
> What can I do???
> guy.
by Andrew J. Kell » Wed, 27 Dec 2000 02:33:05
In addition to BP's reply, you might be able to change char or varchar
columns to Text. If you have that many characters in a row then it usually
is not normalized (hence BP's route) or you have too many large char columns
that might be better served as Text.
Andy
Quote:> Hi all,
> Is it possible to enlarge the total row size?
> I get an error that says: "The total row size (14908) for table 'book'
> exceeds the maximum number of bytes per row (8060)."
> It is immpossible for me to cut this number down as this is an Sybase
> database that I'm transferring to MS-SQL Server.
> What can I do???
> guy.
1. Total Row Size Exceeds Max # of bytes
Just out of curiosity, when I change my datatype in one of my tables
from 'varchar(3000)' to 'varchar(5000)', why would it give me the
message "The total row size (22976) for table 'Jobs' exceeds the
maximum number of bytes per row (8060)"? Even when I change the
datatype to 'Text' it still gives me the same message (And that
character limit is over 2 billion). I'm using Query Analyzer to change
my datatype and I'm using the following statement:
ALTER TABLE Jobs
ALTER Column 'EducationExperience' varchar(5000)
Am I missing something?
I'm only specifying 5000 characters when the limit is 8060 characters
for 'varchar'. Now, my conversion may be wrong. Does 1 byte = 1
character? If so, then why would I get this message if I have 3060
characters left to spare in my row.
If I have the wrong conversion, could someone please explain to me how
datatype row 'character limits' work?
I'm completely baffled. Any help would be greatly appreciated.
Thank You
Sent via Deja.com http://www.deja.com/
Before you buy.
2. More than 16 args to postgres
3. INSERT row size limit exceeded
4. Open server to execute back-end scripts.
5. Worktable row size exceeding limits
6. Need Imput! - Search Engine Technologies?
8. Manually creating FRX files (FPWin)
9. Worktable row size exceeding limits
11. ODBC Driver error 80040e14 Row exceed maximum allowed row size
12. Row size could exeed size limit, wich iss 1962 bytes
13. "Warning: Row size (4068 bytes) could exceed row size limit, which is 4012"