SQL Server session hangs when you try to enable snapshot isolation in SQL Server
Published 07 October 2020
You may see the install or upgrade get stuck on the following SQL:
ALTER DATABASE [RedGateMonitor] SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE [RedGateMonitor] SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE [RedGateMonitor] SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE
This can be due to a problem with SQL Auditing. See: https://support.microsoft.com/en-gb/help/4090966/sql-server-session-hangs-when-you-try-to-enable-snapshot-isolation for further information.