title: foreign keys on table from different database
body: <p>I have two databases in SQL Server and i have a common table for both the databases an important big table which holds the foreign keys to other tables. The problem is the Table is in <strong>DatabaseA</strong>, and I need to refer foreign keys to this table from <strong>DatabaseB</strong>.</p>
  
  <p>I know SQL doesn't support cross database referential integrity so what's the best way to achieve this?  I am thinking of combining two databases and make into single database - it wouldn't matter aside from the increase in complexity.</p>
  
  <p>Any suggestions?</p>