Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Row size exceeded
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Row size exceeded
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01068635
Message ID:
01068635
Views:
70
I created a table just now and got the following message:
'myTable' table
- Unable to create table.  
ADO error: Creation of table 'PresetProgram' failed because the row size would be 42288, including internal overhead. This exceeds the maximum allowable table row size, 8060
I've got several binary fields (length 1K) which is causing the row size to be so insanely large.

I know that if I change the field type to varbinary there is not error and I am able to create my table.
Are there any performance loss choosing varbinary compared to binary?
Is the maximum row size increased in SQL2005?

Thanks,
Einar
Semper ubi sub ubi.
Next
Reply
Map
View

Click here to load this message in the networking platform