sql server replication: Adding columns during replication -- sql server replication

Adding columns during replication

Abdul Rauf
10/29/2004 7:51:05 AM

sql server replication:

Is there any way to add columns to the database and not have to stop
replication.

I have one publisher with many subscribers and I don't want to delete all
the subscriptions to add columns to my publisher.

If this is not the correct way to add columns could you please explain how I
should do it correctly.

Re: Adding columns during replication

Abdul Rauf
10/29/2004 12:56:02 PM

Paul, as always thank you for your help

[quoted text, click to view]

Re: Adding columns during replication

Paul Ibison
10/29/2004 8:21:47 PM

Abdul,
have a look at sp_repladdcolumn.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.