Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- P.[publication] AS [Publication Name]
- ,A.[publisher_db] AS [Database Name]
- ,A.[article] AS [Article Name]
- ,A.[source_owner] AS [Schema]
- ,A.[source_object] AS [Object]
- FROM
- [distribution].[dbo].[MSarticles] AS A
- INNER JOIN [distribution].[dbo].[MSpublications] AS P
- ON (A.[publication_id] = P.[publication_id])
- ORDER BY
- P.[publication], A.[article]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement