Post reply

Do I have replication

  • December 7, 2011 at 4:27 am

    #247900

    Hi - We have lots of replications (push and pull) and I was wondering if there is any way of telling easily if a database is being replicated to? Is it a case that I just need to go through each of the local subscriptions?

    Thanks

  • December 7, 2011 at 4:54 am

    #1417960

    It is possible to easily list the replicated databases:

    select * from sys.databases

    where is_published = 1

  • December 7, 2011 at 5:01 am

    #1417966

    ah cool - its the is_subscribed field I am interested in however, thanks.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply