Q:

Azure SQl Server Cross server Database Queries in Azure SQL Database

hi i have create 1 database in Azure SQL server .Now i want to create procedure using link server.And my other database is on different server not on Azure.So it is giving error .Please help 

A:

Linked servers are not supported in Sql Azure. If both servers were in Azure, you could used elastic database query to do cross database queries within the SQL Azure Server.
Perhaps you could give us a clearer idea of exactly what you're trying to do, and what the exact error is?

