Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a file size limit for a table?
Message
From
19/11/2003 15:10:47
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00850975
Message ID:
00851614
Views:
8
>A single database file (mdf or ldf) has a max size of 32TB. Also, a table may have a max of 1024 columns.
>
>I can't find anything that indicates the max number of columns that can be contained by a single article.
>
>-Mike
>
>>Is there a file size limit on a table. I am trying to add another field to a table and am getting "too many columns in the partition" error.
>>
>>I have a publication on my data and am trying to add this column thru the publication. A smaller table is fine.
>>
>>Thanks

There is also a 8kb limit for record length, isn't there?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform