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 "

You need to create a SP in "DbCustomers" with the name of "LogEvents_Insert" which will be called by following query.

The below query will execute in "DbPayments " and insert data into "LogLogin" of "DbCustomers"

EXEC sp_execute_remote @data_source_name  = N'DbUtilityLogging_Datasource',
@stmt = N'LogEvents_Insert @LoginID',
@params = N'@LoginId nvarchar(50)',



Unknown said...

very very amazing explaintion....many things gather about yourself...yes realy i enjoy it
Digital Marketing company in Chennai

how to improve your grammar said...

The working with a database in this system really simplifies many tasks. The access is complicated by a closed solution that benefits the users