Find the destination owner (schema) for replication on SQL Server

by Bee_Riii   Last Updated January 11, 2018 12:06 PM

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



Related Questions



Full text catalog missing a keyword

Updated August 23, 2017 13:06 PM


MSDTC Issue SQL Server 2008 R2

Updated August 23, 2016 08:04 AM