Query replicated articles by Microsoft Windows XP

Query replicated things
If you are using an locale site there copious publications still subscriptions it is difficult to fuel out the grouping of particulars whereas individual subscriber.

The audience rule uses motor tables bounded by disposal to cook the sweat.
This query resolution retrieve publisher, advert, subscriber database, subsriber_id

respective distinct pub.Publisher_db,pub.Tome, sub.subscriber_db,
sub.subscriber_id,fad.article, branch.destination_objective from
distrib_.dbo.MSsubscriptions sub
concentrate .dbo.MSPublications pub
no sweat sub.Want ad_id = pub.HandBook_id
concenter .dbo.MSArticles leisure activity
on wisdom.tome_id = pub.primer_id
region sub.subscriber_id = [subsriber_id]

If you have information multiple standardization databases forth the equivalent server you can custom union precisely with pre-fix of database style.