>There is also a 8kb limit for record length, isn't there?
The rule is that a row is not allowed to span more than on page. A page is 8192 bytes but you can't use all since some of the space must be allocated to the page header (96 bytes), the row offset table (depends), and some misc housekeeping structures that are on each row.
-Mike
>>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?