设置数据库为SINGLE_USER模式,减少锁定时间

 1 --SQL Server开启READ_COMMITTED_SNAPSHOT
 2  
 3  
 4  
 5 ----设置数据库为SINGLE_USER模式,减少锁定时间 
 6  
 7 ALTER DATABASE ENDV_SOA SET SINGLE_USER WITH ROLLBACK IMMEDIATE
 8  
 9 ALTER DATABASE ENDV_SOA SET ALLOW_SNAPSHOT_ISOLATION ON
10  
11 ALTER DATABASE ENDV_SOA SET READ_COMMITTED_SNAPSHOT ON
12  
13 ALTER DATABASE ENDV_SOA SET MULTI_USER