title: How can I create a dynamic join between 2 SQL Server tables on 2 different servers?
body: <p>I have data in 2 SQL Server 2012 database servers. I need to create a view containing data from both servers. </p>
  
  <p>My first step was to import the join-table from Server2 into Server1 and create the view. The problem is though, that I need to keep the exported table up-to-date and thus a static "export" of the table is not ideal. </p>
  
  <p>What methods could I use in order to create a dynamic join between 2 tables on 2 different servers? </p>