0

Is it possible to use DML commands like insert, update from cross database in azure SQL.

In my requirement I'm running one SP on DB1 after execution i want to update status in a table that belongs to DB2. I'm using azure SQL. Is there any way to call SPs from cross database?

Vandana
  • 1
  • 2

1 Answers1

0

Yes, you can leverage the elastic database query feature which supports Cross-Database Queries. Check sp_execute_remote for details of executing t-sql queries on remote Azure SQL Databases.

Here is a similar thread for your reference: Call stored procedure from Elastic Database in Azure

Community
  • 1
  • 1
forester123
  • 1,549
  • 10
  • 10