OpenQuery function, better?

• Kevin-130791

  SSChasing Mays

  Points: 622

  More actions

  February 8, 2008 at 12:24 pm

  #183761

  I want to copy data from a production table to a different test server, would using the OpenQuery function the best way to do this or can I use a Insert into statement? :doze:

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 8, 2008 at 4:12 pm

  #776648

  You can use the import/export wizard to do this for u. that would be the easiest way that i look ahead.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com