SQL Replication Monitor Question

[lilggg]

Hi Guys,

I am hoping somebody may know where/how I can achieve this.

Currently the only way I know of to add a publisher to replication monitor is via the gui, would it at all be possible to script this somehow? Where is the publisher info stored when viewing replication monitor. This info must be stored locally in the registry or somewhere else and not on the distribution/msdb because it only shows per SQL installation.

I am trying to automate adding a bunch of publishers for a new SQL installation, instead of having to connect to the instance for each publisher in replmon.

Have not been able to find anything usefull on where this info is stored, I have tried searching the registry for some of the Publisher names that I have added, but nothing.

 

[LPCPT]

Normally you have one publisher and one or more subscribers in the replication topology.
You can right click in the gui on the publisher or subscriber and script it out. In SSMS you can almost script out everything. That's what makes it such an excellent product.

 

[lilggg]

Thanks for the reply, i am referring specifically to replication monitor, all the pubs and subs are already setup. So all the pubs showing in the below image, is there a way to add these via script/registry.