更改 MS SQL 2005 隔離層級

select snapshot_isolation_state,snapshot_isolation_state_desc,is_read_committed_snapshot_on from sys.databases

ALTER DATABASE DB_Name
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE DB_Name
SET READ_COMMITTED_SNAPSHOT ON