General information
Forum:
Microsoft SQL Server
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only