MSSQL 2019 – Executing Stored Procedures across Different Databases
I have a staging database [StageDB] and a production database [ProdDB] where data is initially imported from an API into the [StageDB] and then the data inserted or updated into the ProdDB.