Transferring one row to another server

• Bob Mariani

  SSChasing Mays

  Points: 655

  More actions

  June 19, 2004 at 7:04 am

  #108605

  Is there a way to make a script that can take a record from one server and store this in a script that can then be used to transfer this record to another server at another site.  This table contains an image field storing a report that I need to alter at my site and ship to the client.  I cannot alter their tables, only add this new record.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738632

  More actions

  June 19, 2004 at 8:19 am

  #511142

  You can use BCP if the servers cannot see each other or DTS if they can.