SQL MS-Replication: How to find tables (articles) in a Publication

[Steve_Nguyen]

This article briefly explains how to find what tables (articles) are used in a Publication. This method is useful to identify issues when a table does not capture updates. 

Resolution

Run the following query from Microsoft Studio Management or any Database Utility (such as DBeaver):

SELECT 
  msp.publication AS PublicationName,
  msa.publisher_db AS DatabaseName,
  msa.article AS ArticleName,
  msa.source_owner AS SchemaName,
  msa.source_object AS TableName
FROM distribution.dbo.MSarticles msa
JOIN distribution.dbo.MSpublications msp ON msa.publication_id = msp.publication_id
ORDER BY 
  msp.publication, 
  msa.article;

Environment

Qlik Replicate