Interview Questions
1. Is it possible to subscribe to specific articles in a publication (ie not all the articles of the publication)?
According to the documentation, you can only subscribe to a publication. However, assuming you have a publication which consists of several articles (tables) it is possible for each subscriber to subscribe to a subset of the publication. You create the publication and then set up the subscribers as per usual.
Then you drop the unnecessary articles on a per subscriber basis. This only works if your subscribers exist on separate servers, but if you need to do it, the procedure to run is:
sp_dropsubscription ‘publicationname’, ‘tablename’, ‘subscribername’
Or more simply just run sp_addsubscription on a per article basis!
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment