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


Please help me in understanding.


1 Answer 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.

  • This is not working in the case of @sync_method = N'concurrent' publications Commented Sep 19, 2016 at 22:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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