How to find what databases are in replication ???

Question

hi can any one tell me ,How to find what databases are in replication ???

Answer 1

Try this:

select * 
from sys.databases
where is_published = 1 or is_merge_published = 1 or is_subscribed = 1

---

Brandon Williams (blog | linkedin)

Answer 2

Yes, As correctly mentioned by Brandon.. just adding to the post how you can view it by GUI.

Connect SQL Server INstance

Then Expand the Local Publication If the Box is acting as Publisher (You Can Right on Publisher and check out with Publisher Properties for more detailed info), Else Subscriber if its acting as Subscriber....If its Distributor Then you can expand the database then System Database there you see Distributor DB.

And add  

select * 
from sys.databases
where is_distributor= 1

or 

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

Answer 3

thanks

Answer 4

Thanks

Answer 5

One of my database is subscribed via transactional replication and is_subscribed is showing 0 into sys.databases. Any idea why this?

---

Kindly mark the reply as answer if they help