Insert into table on another server

• terry.home

  Ten Centuries

  Points: 1004

  More actions

  December 10, 2015 at 5:00 pm

  #303163

  I want to run a script that inserts data from servers the script is running on into table another server.

  I have done a bit of googling on how to do this and it suggests to use sp_addlinkedserver.

  I might be wrong but at a glance it seems to use this I need to enable SQL Server Authentication.

  Whilst I can enable this, security advice and pen tests have previously advised it best not to enable SQL Server Authentication.

  I am therefore wondering whether there is another way in which I could do this using windows authentication?

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  December 10, 2015 at 6:24 pm

  #1845380

  If you are open to using SSIS, most definitely.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel