Forum Discussion
EXECUTE AS in Azure SQL Managed Instance
Some "last ditch effort" searching to the rescue.
Turns out browsing the crypto functions saved the day - specifically, the CERTENCODED() function:
- Cryptographic Functions (Transact-SQL) - SQL Server | Microsoft Docs
- CERTENCODED (Transact-SQL) - SQL Server | Microsoft Docs
This solution is the kind of "simpler way" I had in mind, I just couldn't find it with my clumsy keyword searches.
I'll mark this as resolved as I'm not expecting any further issues now that the certificate has been copied across, but should anything odd come up with respect to the overall requirement, I'll re-open it with any new specifics.
Cheers,
Lain
Some "last ditch effort" searching to the rescue.
Turns out browsing the crypto functions saved the day - specifically, the CERTENCODED() function:
- Cryptographic Functions (Transact-SQL) - SQL Server | Microsoft Docs
- CERTENCODED (Transact-SQL) - SQL Server | Microsoft Docs
This solution is the kind of "simpler way" I had in mind, I just couldn't find it with my clumsy keyword searches.
I'll mark this as resolved as I'm not expecting any further issues now that the certificate has been copied across, but should anything odd come up with respect to the overall requirement, I'll re-open it with any new specifics.
Cheers,
Lain