How to insert one row from anther server table

• cathyp222000

  Valued Member

  Points: 67

  More actions

  January 10, 2011 at 3:42 pm

  #232843

  Hello:

  I have table1 on serverOne. I would like to insert one row from another server: ServerTwo.table2 to serverOne.table1.

  Is any way to do it?

  Thanks

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  January 10, 2011 at 4:10 pm

  #1271656

  Do you need to do this repeatedly or as a one off?

  If it is one-off and the tables have the same design, just open both tables in SSMS, right-click on the row header for the one you want to copy and select copy, then click on the header for the new row in the target table and paste...

  If it is to be repeated, set up the other server as a Linked Server and then just select the row from it and insert it into your local table.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]