Using VB.NET to find local subscriptions on SQL Express

Tags:
SQL Express
SQL Server
VB.NET
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?
ASKED: June 13, 2008  6:27 PM
UPDATED: June 13, 2008  7:12 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following