查看数据是否开启快照隔离 

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  表示 快照隔离框架已启用

posted @ 2012-09-19 16:12  失忆的烟  阅读(242)  评论(0)  编辑  收藏  举报