1

We have a table replicating to another server with a different Schema at the destination. When I set the replication up it shows as destination owner in the GUI. I am trying to create some reports and need to look at the publication and look for what the destination schema would be.

Unfortunately when I query the table [distribution].[dbo].[MSarticles] the destination owner column is null. Is there somewhere else I can find this info?

Thanks

Improve this question
1
  • 1
    Did you try the [publicationDatabase].[dbo].[sysarticles].dest_owner column? – SqlWorldWide Jan 11 '18 at 13:04
3

Instead of using [distribution].[dbo].[MSarticles] use [publicationDatabase].[dbo].[sysarticles]. Use dest_owner column.

Detail here: https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/sysarticles-transact-sql

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.