Hi folks; i have added a column into a published table using SP_REPLADDCOLUMN.
I get the following message:
Warning: The table 'MY_TABLE' has been created but its maximum row size (8814) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'aonflict_MBDB_PUBLICATION_PTL_PATIENT_CLAIM' has been created but its maximum row size (10801) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
MY_TABLE had 40 columns.
Is there any maximum limit of allowed columns in a published table?
Can anyone explain what are the concequences!I dont think the message you are receiving is related to replication
The 8060 byte limit is a universal limit for the data size of a row. It relates to the maximum amount of data that can be stored on a page.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment