KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a SQL Azure Database Server and I need to query between the Databases but can't figure out how to accomplish this. Here is the structure of my databases: Server.X Database.A Database.B Database.C 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. Is there a way to do this on the database end? In the final version Databases A & C will both need data from Database B.
Tags (comma-separated)
Save Edits
Cancel