| Author |
 Topic  |
|
|
apantig
Posting Yak Master
Cuba
104 Posts |
 Posted - 06/26/2005 : 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.
|
Edited by - apantig on 06/26/2005 22:36:19
|
|
|
madhivanan
Premature Yak Congratulator
India
22460 Posts |
Posted - 06/27/2005 : 00:51:13
|
Can you post the table Structure?
Madhivanan
Failing to plan is Planning to fail |
 |
|
|
apantig
Posting Yak Master
Cuba
104 Posts |
Posted - 06/27/2005 : 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
India
22460 Posts |
Posted - 06/27/2005 : 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
Cuba
104 Posts |
Posted - 06/27/2005 : 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) |
|
|
| |
Topic |
|
Row Size Question
Forum Locked
