Marcello Miorelli
Reputation: 3688
How to get the distributor for a specific publication?
Hi I have several servers that have publications, and some of these servers use different distributors, and in the distributor server, I have several distributor databases.
How can I find out what is the distributor server and distributor database
for a specific Database that I know is published?
I am using sql server 2008 r2,
and I am currently using the stored procedure:
EXEC sp_get_distributor
Upvotes: 1
Views: 1968
Answers (1)
Related Questions
- T-SQL to find if a Database is Subscribed on the Subscriber in Transactional Replication
- T-SQL Query for Replication Articles
- List all tables that are currently published for replication MS-SQL
- How to check for Publisher and Subscriber in transactional replication?
- SQL Server Replication subscribers filter
- How do I add a subscriber to a SQL Server Replication Publisher
- How to look up instance names of publishers and subscribers in distribution database
- "Transactional publication with updatable subscriptions" - gives error - "The distributor has not been installed correctly"
- SQL Server Replication, Distributor
- Publicly available SQL Server replication Publisher