Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there a file size limit for a table?
Message
De
19/11/2003 15:10:47
 
 
À
18/11/2003 15:15:37
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00850975
Message ID:
00851614
Vues:
7
>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
Fil
Voir

Click here to load this message in the networking platform