Post reply

Insert into table on another server

  • 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?

  • December 10, 2015 at 6:24 pm

    #1845380

    If you are open to using SSIS, most definitely.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply