Using VB.NET to find local subscriptions on SQL Express
I have several different SQL Express databases using pull subscription replication with a SQL Server. Different computers will have different databases to replicate with; some have more than one. Is there a way in VB.NET to find all the local subscriptions on the computer running SQL Express?

Software/Hardware used:
ASKED: June 13, 2008  6:27 PM
UPDATED: June 13, 2008  7:12 PM

Answer Wiki:
You can try looking in the msdb.dbo.MSagentparameterlist table. This table holds the parameters for the replication agents. Within this table you should be able to find the databases which have replication going to them. Unless you are using Merge replication that appears to be all you will be able to get from the Subscriber. It appears that the information about the replication is not stored within the subscriber. You will need to connect to the distributor to get this information. Within the Distribution database you can look at the table MSarticles.
Last Wiki Answer Submitted:  June 13, 2008  7:11 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,520 pts.