This post helps you in getting the List of Replicated Tables. Recently some one from Dev team raised a request that he found mismatch for a Table on all replicated servers. At the routing server the table contains 6 rows and at some of the partition (Subscribers) the table contains 3 rows and remaining are at the proper sync levels. Now we need to check whether the table is subscribed to those where data is missing.
To check that we could finally came with a Query which can save a lot of time. Lets assume the table name is “Test_Table” the connect to the publisher database and run the below query it’ll give us the total subscribers details to which the Table is subscribed
SELECT
pub.name AS [Publication],
art.name as [Article],
ser.name as [Subsriber],
sub.dest_db as [DestinationDB]
FROM
dbo.syssubscriptions sub
INNERJOINsys.servers ser ON ser.server_id = sub.srvid
INNERJOIN dbo.sysarticles art ON art.artid = sub.artid
INNERJOIN dbo.syspublications pub ON pub.pubid = art.pubid
WHERE art.Name='Test_Table'
The above query get you the list of replicated tables.
