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 |
|
jsiedliski
Yak Posting Veteran
61 Posts |
 Posted - 2003-04-05 : 02:01:03
|
| Is there a major issue in making a table which would allow a row of data to exceed 8K?I am talking about INT, CHAR and VARCHAR fields (No text, ntext and image fields in my table)I know that a page of data is 8K and I guess one record must fit on a page?Also, sometimes, SQL Server throws out a warning when I make changes to this table. This is what leads me to believe that I could run into problems if I actually used up more than the 8k. Here is the message:Server: Msg 1701, Level 16, State 2, Line 1Creation of table 'products' failed because the row size would be 8110, including internal overhead. This exceeds the maximum allowable table row size, 8060.Anyway, I would love to know if I should limit all fields in a table to a total of 8k.Thanks,Jack |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-04-05 : 02:07:05
|
| That is correct.You can create a table whose fields would exceed that limit, but if you try to insert a record that exceeds it, your insert will fail. That is the warning you are getting.Damian |
 |
|
|
|
|
|
row length > 8K