Ads

10 April 2015

Query to verify Replication on the SQL Server Instance

 select name, is_published, is_subscribed, is_merge_published, is_distributor
  from sys.databases
  where is_published = 1 or is_subscribed = 1 or   is_merge_published = 1 or is_distributor = 1

1 comment:

  1. What should be the output of this to make sure replication is valid?

    ReplyDelete