SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Row Size Question
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

apantig
Posting Yak Master

Cuba
104 Posts

Posted - 06/26/2005 :  22:33:39  Show Profile
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.




Edited by - apantig on 06/26/2005 22:36:19

madhivanan
Premature Yak Congratulator

India
22755 Posts

Posted - 06/27/2005 :  00:51:13  Show Profile  Send madhivanan a Yahoo! Message
Can you post the table Structure?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

apantig
Posting Yak Master

Cuba
104 Posts

Posted - 06/27/2005 :  01:14:47  Show Profile
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)
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22755 Posts

Posted - 06/27/2005 :  01:22:55  Show Profile  Send madhivanan a Yahoo! Message
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
Go to Top of Page

apantig
Posting Yak Master

Cuba
104 Posts

Posted - 06/27/2005 :  01:39:21  Show Profile
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)
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000