Azure Managed Instance – how to do a cross-database service broker certificate
I have migrated processes from on-prem to Managed Instance. In one case I have an activated stored procedure (service broker) that does a cross-database query. I have no idea how this worked beforehand – I suspect the database was marked TRUSTWORTHY (I have the backup but no idea how to tell, and restoring the DB removes that). I’d rather do it properly.