Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106

    Unanswered: Replication problem

    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!

  2. #2
    Join Date
    Oct 2003
    Location
    Newcastle, Australia
    Posts
    51
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •