启用sqlserver2005快照隔离

启用sqlserver2005快照隔离,方法如下:
ALTER DATABASE YourDataBaseName SET ALLOW_SNAPSHOT_ISOLATION ON;
ALTER DATABASE YourDataBaseName SET READ_COMMITTED_SNAPSHOT ON;

posted @ 2011-11-01 11:39  wwh  阅读(236)  评论(0编辑  收藏  举报