Linked server - repl_distributor - what is this?? 1

[icemel]

Hi,

When I run sp_linkedservers, I get a list of servers, which includes this entry:

repl_distributor

I don't know what this is - we do not have any servers by this name.

Also, is there an easy way to script create statements all the linked servers? That is, the statements for re-creating the linked servers.

Thanks!

 

[Catadmin]

Repl_distributor is not an actual server name. It is an indicator meaning you have an entry somewhere in your replication tables for a remote linked distributor server. Do you use replication?

If you don't use replication, you can remove all references to it by using the sp_removedbReplication. If you do use replication, though, you'll want to leave it alone or you'll kill replication. The distributor is essentially to moving subscriptions.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.