SQL Server session hangs when you try to enable snapshot isolation in SQL Server
Published 14 February 2023
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.
This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved
