SQL Monitor 12

SQL Server session hangs when you try to enable snapshot isolation in SQL Server

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. Seehttps://support.microsoft.com/en-gb/help/4090966/sql-server-session-hangs-when-you-try-to-enable-snapshot-isolation for further information.



Didn't find what you were looking for?