设置数据库为SINGLE_USER模式,减少锁定时间
时间:2022-03-14 02:46
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