Replication adds a linked server?

• Dave-3000

  SSCertifiable

  Points: 6186

  More actions

  May 29, 2008 at 3:36 pm

  #93480

  We are moving from a server with SS2000 on it to a different box with SS2005. I used a script I found here on SSC.com to generate the stored proc calls that will create my linked servers. In addition to the linked servers I know I created, it also generates statements for a server named "repl_distributor". I'm guessing that this was created when we set up replication. So then when we recreate the replication on the new server, the repl_distributor server link will be added automagically. True? Thanks.

  Here are the statements the script generated:

  --------------------------------

  sp_addlinkedserver

  @server = 'repl_distributor'

  , @srvproduct = 'SQL Server'

  GO

  sp_serveroption

  @server = 'repl_distributor',

  @optname = 'rpc',

  @optvalue = 'false'

  GO

  sp_serveroption

  @server = 'repl_distributor',

  @optname = 'rpc out',

  @optvalue = 'false'

  GO

  sp_serveroption

  @server = 'repl_distributor',

  @optname = 'data access',

  @optvalue = 'false'

  GO

  sp_serveroption

  @server = 'repl_distributor',

  @optname = 'rpc',

  @optvalue = 'true'

  GO

  sp_serveroption

  @server = 'repl_distributor',

  @optname = 'dist',

  @optvalue = 'true'

  GO

  sp_serveroption

  @server = 'repl_distributor',

  @optname = 'rpc out',

  @optvalue = 'true'

  GO

  sp_serveroption

  @server = 'repl_distributor',

  @optname = 'system',

  @optvalue = 'true'

  GO

  sp_serveroption

  @server = 'repl_distributor',

  @optname = 'use remote collation',

  @optvalue = 'true'

  GO

  sp_addlinkedsrvlogin

  @rmtsrvname = 'repl_distributor',

  @useself = 'false',

  @locallogin = NULL,

  @rmtuser = 'distributor_admin',

  @rmtpassword = ''

  GO

  sp_setnetname

  @server = 'repl_distributor',

  @network_name = 'DCSF2SQL '

  There is no "i" in team, but idiot has two.