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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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