title: Can't query between databases in SQL Azure
body: <p>I have a SQL Azure Database Server and I need to query between the Databases but can't figure out how to accomplish this. </p>
  
  <p>Here is the structure of my databases:</p>
  
  <ul>
  <li><strong>Server.X</strong>
  <ul>
  <li><strong>Database.A</strong></li>
  <li><strong>Database.B</strong></li>
  <li><strong>Database.C</strong></li>
  </ul></li>
  </ul>
  
  <p>In <strong>Database.A</strong> I have a Stored Procedure that needs to retrieve data from <strong>Database.B</strong>.  Normally, I would reference the database like <code>SELECT * FROM [Database.B].[dbo].[MyTable]</code> but this does not appear to be allowed in SQL Azure. </p>
  
  <p><code>Msg 40515, Level 15, State 1, Line 16
  Reference to database and/or server name in 'Database.B.dbo.MyTable' is not supported in this version of SQL Server.</code></p>
  
  <p>Is there a way to do this on the database end? </p>
  
  <p>In the final version Databases A &amp; C will both need data from Database B.</p>