Monday, March 19, 2012

Can named subscribers be added as a group

When using named subscriptions, can a group be added to the list of
replication partners, or does each subscrber need to be added individually?
It must be done individually.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Tony Toker" <xxxx@.xxxx.com> wrote in message
news:cellc1$q4i$1$8302bc10@.news.demon.co.uk...
> When using named subscriptions, can a group be added to the list of
> replication partners, or does each subscrber need to be added
individually?
>
>
|||Tony,
each one has to be added separately, but if you have a list, you could use
SQL DMO to add them in a loop. I have added a couple of scripts to create
publications and subscribers using VB.Net and SQLDMO on
www.replicationanswers.com.
HTH,
Paul Ibison

No comments:

Post a Comment