select 1000 records from one table into another in a different server (linked server)

• aditi.shirke

  Grasshopper

  Points: 15

  More actions

  February 29, 2016 at 12:33 am

  #324557

  I need to transfer only top 1000 records from a table on one server to another table on another server. How can this be achieved using linked servers.

• tony28

  SSCertifiable

  Points: 7114

  More actions

  February 29, 2016 at 12:49 am

  #1861730

  If you have set linked server, on current server execute something like this.

  INSERT INTO DATABASE.schema.TABLE

  SELECT TOP 1000 * FROM LINKEDSERVER.DATABASE.schema.TABLE WHERE ...

  if you dont have try to read this article https://msdn.microsoft.com/en-us/library/ff772782(v=sql.110).aspx and you have to set on target server.