When I set a lock on the Resource Group where my Azure SQL Server and DB reside - I can still delete the DB using SQL Server Management Studio This action should at least generate a prompt in SSMS indicating a Resource Lock has been set5 votes
SSMS doesn’t know anything about Azure resource groups at this time. I suspect the lock only applies to the ARM REST API. Perhaps this suggestion should be copied over to Azure SQL Database; they could check for this lock on the server side and fail the TSQL query.
- Don't see your idea?