Azure sp_execute_remote / Cross Database query in Sql Azure.

Cross database query is not allowed in Sql Azure. Rather Azure has applied a different logic to use the same. Please check my article before proceeding with "sp_execute_remote " http://an-it-solution.blogspot.in/2017/01/sql-azure-select-from-another-database.html You need to create a SP in "DbCustomers" with the name of "LogEvents_Insert" which will be called by following query. The below...

Share:

Sql azure select from another database / Cross Database connection

Cross database query Sql Azure Azure cross database query performance sql azure select from another database reference to database and/or server name in is not supported in this version of sql server. All the above statements are reference to the issue we face while shifting data from Sql Server to Azure Database. While using Sql Server (Any version) we can reference any database with in Sql...

Share: