It is a warning that says that if you insert data into that table in a
single SQL call where the total number of bytes in a row exceeds 8060, then
the rows will not be inserted, and you will need to split the row to be able
to insert all of the data. If you want to resolve this error, how many
fields are in this table? Are you using varchar(8000) or something like
that? You only added 4 bytes to the table (int is 4 bytes), so perhaps the
solution to not have possible data loss in an autonomous operation would be
to normalize the table more or to split the table (if normalization is not
possible.
hth...
David L. Penton
"Mathematics is music for the mind, and Music is Mathematics for the
Soul." - J.S. Bach
[EMAIL PROTECTED]
"If you want an ISP with great Network
connectivity and great email,
DON'T use AT&T @Home"
-----Original Message-----
From: Palyne Gaenir
I attempted to alter a table by adding a column. I got an error I
haven't got before. Alas my SQL book has a whole bunch but not this
one (they were selective). I can read of course, I know what it
says, but I don't see why adding a reference to a primary ID column
in another table would cause a problem. The name isn't long. Below
is the error message. I hope someone can help me... I only seem to
have major problems Friday to Sunday when few people are on the
lists. :-( Thanks very much. PJ
ODBC Error Code = 01000 (General warning)
[ODBC SQL Server Driver][SQL Server]
The total row size (12440) for table 'ttbcqa' exceeds the maximum
number of bytes per row (8060). Rows that exceed the maximum number
of bytes will not be added.
SQL = "alter table ttbcqa add tbid int not null references
ttestbank(tbid) ;"
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
