List of Replicated Tables

List Of Replicated Tables

 

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

The above query get you the list of replicated tables.

Posted in Uncategorized | Tagged , , , | Leave a comment

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz