Home Forums SQL Server 2014 Development - SQL Server 2014 Query Stuck causing Locks, but I see SP:StmtCompleted in SQL Profiler RE: Query Stuck causing Locks, but I see SP:StmtCompleted in SQL Profiler

  • November 16, 2016 at 5:01 pm

    #1912937

    Hey guys

    I found the solution. I had to enable Snapshot Isolation on my database

    ALTER DATABASE MyDatabase

    SET ALLOW_SNAPSHOT_ISOLATION ON

    Thank you for all the answers