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.
| Author |
Topic |
|
sogibear
Starting Member
1 Post |
 Posted - 2002-07-30 : 06:30:39
|
| I have a table with a lot of fields(over 100) when i try and add any more, i get an error message saying :"- Unable to modify table. ADO error: Cannot create a row of size 8068 which is greater than the allowable maximum of 8060.The statement has been terminated."Is there a way to make the MSDE handle a bigger Row size bigger |
|
|
macka
Posting Yak Master
162 Posts |
Posted - 2002-07-30 : 06:37:01
|
| A 100+ columns for a table seems a little excessive! Sounds like you may need to re-think your design a little.What kind of data are you trying to store ?macka. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-30 : 06:58:01
|
| The 8,060 byte per row limit is fixed in SQL Server and MSDE, it is the size of a data page. I agree with macka, you may want to reconsider your table design, or post the exact structure here. |
|
|
|
|
|
|
MSDE Engine