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?