1

Can we filter the articles in the publication (which has few subscribers already) while adding the new subscriber?

look at the last statement ‘Subscribing to individual articles within a publication can get tricky’ in the below article

http://www.sqlservercentral.com/blogs/kendalvandyke/2010/08/31/replication-gotcha-2D00-including-an-article-in-multiple-publications/

Please help me in understanding.

1

The stored procedure sp_addsubscription allows for you to specify that you want all articles (i.e. tables) or just one. If you want a subset of articles in a publication, you just need to run the sp_addsubscription once for each article that you want. It looks like the sp_addsubscription defaults to @article = 'all' My suggestion is to go through the New Subscription Wizard and have it generate the script only. Then you can go in and modify the script as you need it. You would need to add multiple sp_addsubscription lines.

| improve this answer | |
  • This is not working in the case of @sync_method = N'concurrent' publications – user1424196 Sep 19 '16 at 22:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.