Script to show Replication Topology

Chris Skorlinski, Microsoft SQL Server Escalation Services

I came across this forgotten but very handy script from my friends Suhas and Gaurav to display your Replication topology. The output below is from SQL 2016 sample publications using AdventureWorksLT.

https://gallery.technet.microsoft.com/Display-Replication-b15e730c

=============================================================

REPLICATION TOPOLOGY

=============================================================

SELECT THE PUBLICATION-SUBSCRIPTION PAIR FOR SCOPING THE CASE

=============================================================

SQL2016 (DISTRIBUTOR :: 13.0.2149 X64) (Distribution Database: distribution)

|- PUBLISHERS

|- SQL2016 (Publisher 1)

|- PUBLICATIONS

|- TranSales (Publication ID: 1; Publication type: Transactional (1-way); Publication database: AdventureWorksLT)

|- ARTICLES

|- 2 article(s); Reserved Space = 184 KB, Used Space = 184 KB, Index Space = 48 KB

|- SUBSCRIPTIONS

|- SQL2016_REPORTING (Subscription Database: TranSales_Subscriber; Subscription Type: Push)

|- MergeCustomer (Publication ID: 2; Publication type: Merge; Publication database: AdventureWorksLT)

|- ARTICLES

|- 3 article(s); Reserved Space = 704 KB, Used Space = 552 KB, Index Space = 248 KB

|- SUBSCRIPTIONS

|- SQL2016_REPORTING (Subscription Database: MergeCustomer_Subscriber; Subscription Type: Push)