title: How to do a union across multiple instances of Sql Server?
body: <p>I have two Sql Servers (two distinct databases, (i.e. two machines)) with the same structure. Is there a way to do a SELECT * FROM (SELECT * FROM TableOnServerA Union SELECT * FROM TableOnServerB)?</p>
  
  <p>Thanks</p>