We are using Snapshot replication.
I want to know the answer of 3 questions from below.
1)which Replication Topologies are
our server using? like Central publisher,central subscriber,Central publisher with
remote distributor ...etc
2)who is publisher? who is subscriber? who is distributor?
3)which is publication? which is articles? which subscription?
Is any query to find or any method to find out?
I did nt want explanation of publisher,subscriber,distributor etc. I want to know who
or subscriber or distributor in current using sql server
A Central Publisher is where your publisher and distributor resides in same server and you have subscriber in another server. If your distributor is not in the publisher server then your in Central Publisher with remote distributor. A Central Subscriber is where you have multiple publications replicate data to a single article this is done using filter option in article property. e.g say you want to replicate data from different sales region (based on SalesID) to a central subscriber table (with all sales region data) you should consider Central Subscriber method.
There are various system tables and stored procedures to get the details about publisher, subscriber and distributor info.
answered Jan 22, 2013 at 12:58 PM
ok thank you anuj it help me a lot..........
answered Jan 23, 2013 at 06:24 AM