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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    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