title: Connect two tables from different databases on same server
body: <p>Is it possible to connect two tables from different databases on the same SQL Server 2008 R2 instance? When one is being updated or inserted into, the other table should be updated automatically.</p>
  
  <p>Example:</p>
  
  <ul>
  <li><code>Table 1</code> from Customer database</li>
  <li><code>Table 2</code> from Supplier database</li>
  </ul>
  
  <p>When something is inserted into <code>Table 1</code>, at the same time <code>Table 2</code> should be updated with same data of <code>Table 1</code>.</p>