SQL Server Performance Forum – Threads Archive

modifying table structure in Publisher DB

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: â€œ Cannot add columns to table ‘xyz’ because it is being published for merge replication.â€ So how can I do the modification without stopping the replication process? Any idea? Thanks.. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]

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.

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].

Is that a suggestion or a question [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing.</center>

]]>