Home > IT Answers > SQL Server > Using VB.NET to find local subscriptions on S...

Question

Asked: Jun 13 2008 6:27 PM GMT
Asked by: SQL Server Ask the Experts

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?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.

Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER

View History

RATE THIS ANSWER

0
Click to Vote:

Last Answered: Jun 13 2008 7:11 PM GMT by Mrdenny

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.