We have a requirement to perform SQL Azure to SQL Azure database communication for a client that we are working with.
We believe that this is unsupported. To prove this we setup two SQL Azure databases (1 + 2) under the same SQL Azure server. When we try to query one from
the other using a simple TSQL statement, for example:
As of now the cross database reference is not supported. However, it is one of top voted feature on
SQL Azure feature voting on mygreatwindowsazureidea.com - you can view the requested feature
here - i encourage you to go and vote for your feature as one of my idea was completed in the recent release and the team is definetly monitoring this forum.