Groups | Blog | Home
all groups > sql server replication > june 2007 >

sql server replication : Add multiple columns with sp_repladdcolumn


Steve
6/18/2007 11:01:02 AM
I need to add multiple new fields to a replicated table. There are sveeral
subscriptions to the publication that contains this article. Can
sp_repladdcolumn be used to add more than one field at a time? Everytime I
add a field using Enterprise Mgr, it takes a while to update all of the
subscriptions. I was hoping that I could add more than one field to an
article and then update all of the subscriptions to that article.


Thank You

Paul Ibison
6/18/2007 8:46:44 PM
No - just one at once. But you could turn off the distribution agents, add
all the columns then synchronize to get them applied all together.
HTH,
Paul Ibison

AddThis Social Bookmark Button