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
Run sp_helpdistributor in the publication database.