Row Size Question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Row Size Question

Author

Topic

apantig
Posting Yak Master

104 Posts

Posted - 2005-06-26 : 22:33:39

Hi,

It says on Error 511 from BOL that it cannot create
a row of size of %d (ie.8062) which is greater than the allowable
maximum of %d (ie. 8060). This is the Explantion from BOL: "This error occurs when you attempt to insert a row that is larger than the maximum defined table. This error occurs if the row you attempt to insert into a table is too big to fit into a data page. in MS SQL Server, the maximum allowable size of a row in a table is 8060 bytes. A row cannot be split across data pages. A data page is 8KB in size and consists of the data row and some internal data structures.

Action: Change the data being inserted so it does
not exceed the maximum number of bytes (8060) that can be stored
in a single row."

Guys, this has been my big problem and hoping your help. These are my questions from the above BOL statement.

1. What does "that is larger than the maximum defined table"
mean? Does the word DEFINE here mean that I can define a maxium
number of bytes per row?

2. It suggests that I must change the data being inserted so it does
not exceed that maximum number of bytes (8060). What if my table
really requires that much? I mean, I have a table that saves Remarks1
and Remarks2. These 2 columns have only 500 Characters maximum size.

3. Is there a way to change maximum bytes per row?

Guys, thank you very much for your sure suggestions.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-06-27 : 00:51:13

Can you post the table Structure?

Madhivanan

Failing to plan is Planning to fail

apantig
Posting Yak Master

104 Posts

Posted - 2005-06-27 : 01:14:47

Thanks for your reply. Here are my 2 tables. Originally, this was only one table including the Remarks1 and Remarks2 but I decided to split the table thinking that it might help.

Tables:

ScheduleOfAR

1. BuyerCode Char(8)
2. CutOffDate DateTime
3. ProjectCode Char(3)
4. Balance Decimal(13,2)
5. AmountDue Decimal(13,2)

ScheduleOfAR_Remarks

1. BuyerCode Char(8)
2. Remarks1 Char(500)
3. Remarks2 Char(500)

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-06-27 : 01:22:55

Inserted length of your remarks is more than 500, you will get error
Increase that size as you want

Madhivanan

Failing to plan is Planning to fail

apantig
Posting Yak Master

104 Posts

Posted - 2005-06-27 : 01:39:21

Actually on my s/p, I only use Substring(@rem1,1,499) for Remarks1 and
Substring(@rem1,500,499) for Remarks2. The Size of @REM is Char(1000)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources