isolation Level 보기 및 변경하기

dbcc useroptions

ALTER DATABASE testdb
    SET READ_COMMITTED_SNAPSHOT ON;

SELECT NAME, SNAPSHOT_ISOLATION_STATE,
SNAPSHOT_ISOLATION_STATE_DESC, IS_READ_COMMITTED_SNAPSHOT_ON
FROM SYS.DATABASES