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

Reply via email to