Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
>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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement