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