I have an SQL Azure Database & I need to query between the Databases but I am not able to figure out, how to do it?
Here is the database's structure:
In Database.A I have a Stored Procedure that needs to retrieve data from Database.B. Normally, I would reference the database like SELECT * FROM [Database.B].[dbo].[MyTable] but this does not appear to be allowed in SQL Azure.
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.
I need a way to do this.
In the final version Databases, A & C will both need data from Database B.