トランザクション分離レベルの確認

#確認
DBCC USEROPTIONS

#Sessionレベルでの変更
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
SET TRANSACTION ISOLATION LEVEL SNAPSHOT
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

#DatabaseレベルのREAD COMMITTED SNAPSHOT 設定の有効化
ALTER DATABASE [データベース名] SET READ_COMMITTED_SNAPSHOT ON