Solved

The table has been created but its maximum row size (14757) exceeds the maximum number of bytes per row (8060).

Posted on 2011-09-27
4
331 Views
Last Modified: 2012-05-12
Hello Experts,

Can anyone tell me what does this warning actually means?

The table has been created but its maximum row size (14757) 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.

Anything i should be worried off? Any reliability issues i can face in future? FYI i am running this on SQL 2000.

Thanks,
Rithesh
0
Comment
Question by:Star79
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 36712555
the total of your fields' length is > 8060
0
 
LVL 21

Accepted Solution

by:
JestersGrind earned 500 total points
ID: 36712586
The maximum row size of a table in SQL Server is 8060 bytes like the error message says.  To keep it simple, you can create a table with two VARCHAR(8000) columns.  Even though it potentially could exceed 8060, SQL will still let you create it, but if I insert 5000 characters into each column, the insert will fail.  14757 is way over that limit.  I would examine the table structure.  Are there any columns that have been overestimated?  Are there any large varchar columns that could be text instead?  The text data type stores data as a BLOB (binary large object), so it actually stores the data outside of the row in a special area.

Greg

0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 36715227
is the data normalised?

would it be better to store  the data on multiple rows / tables...

what will be your strategy when the user data exceeds 8060 bytes?
0
 
LVL 25

Expert Comment

by:TempDBA
ID: 36813017
You should check for the schema of the table. Why your table schema is as such that it has to store so much in a single row. What datatypes you are using with what lenghts? Can you post the structure of your table here?
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question