Question about linked servers

[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!

 

[agoeddeke]

icemel,

Look up the stored procs:

sp_addlinkedserver
sp_addlinkedsvrlogin

In the Books Online. It should explain everything you need. Can't help you on what repl_distributor is - sorry.

Andy

 

[icemel]

Well, I found this article online about generating a script for linked servers:

http://www.codeproject.com/cs/database/ScriptLinkedServers.asp

However, it seems a bit complicated and not worth the effort at this point, but maybe useful for someone else?