0

it is not my way to check the replication, however, on this instance I have many publishers on my replication monitor, as you can see on the picture below:

enter image description here

where does sql server store the publishers names that are on the replication monitor?

If knowing where this info is stored I might have a way to automate, or export, import it.

Just clarifying the question here: I run the replication monitor from my own laptop. I have no live databases on my laptop. I have a set of publishers added to the replication monitor that sits on my laptop, and you can see it is a long list, each publisher is a different serve.

I am not after data about each publication, for that I have the queries here.

I would like to know where does sql server saves (presumably on my laptop) the names of the publishers I added to my replication monitor.

Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320

1 Answers1

1

where does sql server store the publishers names that are on the replication monitor?

It is stored in the database for which the Publication comes from (i.e. the publishing database). You can query it a number of ways, but in particular dbo.syspublications would probably be easiest:

Contains one row for each publication defined in the database. This table is stored in the publication database.

In particular you want the name field:

The unique name associated with the publication.

J.D.
  • 40,776
  • 12
  • 62
  • 141