Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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
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
