configuring linked servers question

• Dan121

  SSCommitted

  Points: 1616

  More actions

  February 11, 2015 at 1:20 pm

  #304197

  I have 2 instances on my laptop. I am trying to copy some table from 'abc123' server to xyz123 server. I found this online and it's not working!!! can some one help or is there steps thru GUI online?

  EXEC sp_addlinkedserver

  @server=N'HOGEN-PC', -- Remote Computer Name

  @srvproduct=N'', -- Not Needed

  @provider=N'SQLNCLI', -- SQL Server Driver

  @datasrc=N'HOGEN-PCSQLEXPRESS'; -- Server Name And Instance

• CooLDBA

  Hall of Fame

  Points: 3301

  More actions

  February 11, 2015 at 1:57 pm

  #1777067

  https://technet.microsoft.com/en-us/library/ff772782(v=sql.105).aspx