Hi Thimo König •,
On Azure SQL Managed Instance, this works without the need of the single user mode (which is by the way not supported on the Azure SQL MI):
Hope this helps.
Thanks
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
We want to make a change to the configuration of a DB which seems to be done best when there are no active users/connections to the DB. In our case we want to set READ_COMMITTED_SNAPSHOT to ON
We thought of using SINGLE_USER Mode like described here: https://learn.microsoft.com/en-us/sql/relational-databases/databases/set-a-database-to-single-user-mode?view=sql-server-ver16 to make sure all current sessions are closed before we apply the change. But this feature is not supported by a managed instance. So we wonder what would be the best approach to apply such a change on a managed instance?
Hi Thimo König •,
On Azure SQL Managed Instance, this works without the need of the single user mode (which is by the way not supported on the Azure SQL MI):
Hope this helps.
Thanks