Data transfer between 2 SQL Server

• vsv

  Mr or Mrs. 500

  Points: 578

  More actions

  November 3, 2006 at 11:06 pm

  #61568

  Please help me

  I want to transfer data from one SQL Server database to another Remote SQL Server database

  We can use only SQL statements/Stored procedures

  Login into the remote server

  Select data from local server database and insert it into remote server database

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  November 6, 2006 at 4:42 am

  #670006

  use remote procedure calls via linked server enabled for rpc calls only. Check out BOL

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/