In Azure if you have two or more SQL Databases and you want to perform a query across them, you might come across the following error:
1 | Reference to database and/or server name in '[database table]' is not supported in this version of SQL Server. |
In order to perform cross database queries among SQL Azure databases you need to use the elastic database query feature. What is the Elastic Database Query Feature? The elastic database query feature enables you to run a Transact-SQL query…