Forum Discussion
"ALTER DATABASE CURRENT SET ALLOW_SNAPSHOT_ISOLATION ON" does not finish for several hours
I have tried enabling snapshot isolation on several SQL Server instances (2017 and 2022 developer editions) in single user mode with the same huge DB (4 TB) but the command does not finish even after...
Found the workaround myself:
https://support.microsoft.com/en-us/topic/sql-server-session-hangs-when-you-try-to-enable-snapshot-isolation-in-sql-server-2016-e7704e62-226e-1844-3d1a-7be9739e0bc5