October 12, 2009 at 4:46 am
i want to know what to do this warning message in SQL 2000 "The table has been created but its maximum row size (9641) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes."
October 12, 2009 at 6:04 am
You've obviously created a table with some lengthy VARCHAR columns.
As the message tells you, the maximum size of a row is 8060 bytes.
Although the table has been created, and you will be able to insert and update rows quite happily, there is the potential that you could try to insert a row where the total length of the columns in a row would exceed this maximum... which would fail.
October 12, 2009 at 7:28 am
You shouldn't create tables accepting more than 8060 characters in the design, or use TEXT fields. That way you will not run into this error.
It's a warning only, and the behavior is the same as other tables, other than what Ian mentioned.
October 12, 2009 at 8:09 am
I agree *generally* with Steve, you really shouldn't create tables that exceed the 8060 number. There are *very few* reasons to do so. You should shrink your varchar columns up some or switch a big one to TEXT.
This is a warning only BUT if you try to insert a row that contains too much data it WILL fail. All other rows will succeed if you are inserting one-by-one.
CEWII
October 12, 2009 at 8:11 am
Yep, good answer
Why is this a POLL anyways?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply