22,210
社区成员
发帖
与我相关
我的任务
分享
alter database dbname
set READ_COMMITTED_SNAPSHOT ON
GO
--先做这个:
--exec sp_who
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
--再做这个:
alter database dbname
set READ_COMMITTED_SNAPSHOT ON
GO
--行得通
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
alter database Havana
set READ_COMMITTED_SNAPSHOT OFF
GO
--ALLOW_SNAPSHOT_ISOLATION
alter database Havana
set ALLOW_SNAPSHOT_ISOLATION ON
GO