Showing posts with label Snapshot Isolation. Show all posts
Showing posts with label Snapshot Isolation. Show all posts

Thursday, May 20, 2010

MS SQL: Resolve deadlocks - Snapshot Isolation

ALTER DATABASE MVIC_Banksy
SET READ_COMMITTED_SNAPSHOT ON;
GO

ALTER DATABASE MVIC_Banksy
SET ALLOW_SNAPSHOT_ISOLATION ON;
GO