Skip to content

Instantly share code, notes, and snippets.

@chenbojian

chenbojian/query-replication-tables.sql

Created May 7, 2020 19:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chenbojian/cc6709892d425e59d91c7decac17d860 to your computer and use it in GitHub Desktop.
Save chenbojian/cc6709892d425e59d91c7decac17d860 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query-replication-tables.sql
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment