SQL Server Performance

modifying table structure in Publisher DB

Discussion in 'Performance Tuning for SQL Server Replication' started by essam636, Apr 21, 2004.

  1. essam636 New Member

    I am implementing merge replication between 2 Databases running on SQL2000, when I try to modify a structure of one table in the publisher database, it displayes an error says:<br />“ Cannot add columns to table 'xyz' because it is being published for merge replication.”<br /><br />So how can I do the modification without stopping the replication process?<br />Any idea?<br /><br />Thanks..<br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  2. satya Moderator

    In SQL server 2000, we can execute sp_repladdcolumn/sp_repldropcolumn to add/drop a column on a replicated table.

    Otherwise, you have to drop the subscriptions and the publication, then add/drop column, and then receate the replication settings.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. anrovi New Member

    If you need to add a column there is an very easy method to do it:
    Execute enterprise manager and go to properties of your publisher where is your table. On [filter columns], below window, there is a button named [Add column to table].
  4. satya Moderator

    Is that a suggestion or a question [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>

Share This Page