Lesson Learned #331: ALTER DATABASE XXX SET READ_ONLY WITH NO_WAIT
Today, we got a service request that our customer reported that they need to change to readonly a database in Azure SQL Managed Instance using the TSQL: ALTER DATABASE xxx SET READ_ONLY WITH NO_WAIT. Currently, this option is not supported and we have many other options to have a database in readonly, like ReadScale for Business Critical, Replication, change to readonly the users, etc.. However, our customer needs to use the same Azure SQL Managed Instance.
