SQL Server session hangs when you try to enable snapshot isolation in SQL Server
Published 02 October 2019
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.
