select name,snapshot_isolation_state,snapshot_isolation_state_desc from sys.databases
name snapshot_isolation_state snapshot_isolation_state_desc
-------------- ------------------------ ------------------------------------------------------------
master 1 ON
tempdb 0 OFF
model 0 OFF
msdb 1 ON
Smoke 1 ON
snapshot_isolation_state 值为1 并且snapshot_isolation_state_desc值为ON 表示 快照隔离框架已启用