Any t-sql to find out if DB is replicated? IE P2P, Merge/ etc

Question

Post reply

Any t-sql to find out if DB is replicated? IE P2P, Merge/ etc

Dexter Plaras

Ten Centuries

Points: 1000
More actions
April 2, 2012 at 9:45 am

#266484

Need to find a dmv/script to find out if a particular db is replicated or not. Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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

george sibbald SSC Guru Points: 104210 More actions · Answer 1

is_published is_subscribed is_merge_published is_distributor from master.sys.databases will be = 1

---------------------------------------------------------------------

Dexter Plaras Ten Centuries Points: 1000 More actions · Answer 2

p2p works for is_published but if it just a regular transaction replication someone that flag isn't set. Thanks

george sibbald SSC Guru Points: 104210 More actions · Answer 3

strange, it is for me. You are after the publisher right?

---------------------------------------------------------------------

Dexter Plaras Ten Centuries Points: 1000 More actions · Answer 4

I want is_published and is_subscribed to work. I have p2p replication for this one DB which also populates to another DB downstream but someone it's not setting the is_subscribed flag to true. This is for sql2k8 sp3 server.