A Repasky

A Repasky

  • NA
  • 231
  • 183.2k

How to use tables from 2 different servers.

Jan 16 2013 12:57 PM
I need to get to tables on 2 different servers and use them in a query.  I thought if I did a bulk copy and put them on the main server, by truncating a new table (s) on the new server and then do the bulk copy.  My boss said that will not work because the tables are too large.  How can I do this.

2 tables are on server 1 and need to use them on server 2.

arep

Answers (2)