开启read_committed_snapshot 读快照隔离级别的方法

--修改sqlserver 数据库隔离级别

--开启read_committed_snapshot 读快照隔离级别，推荐值是1：

--可以解决sqlserver大多数无脑死锁现象

select name,is_read_committed_snapshot_on from sys.databases where name = 'kingdee_prod'

use master
declare @dbname as sysname
declare @sql varchar(max)

set @dbname='kingdee_prod'

set @sql=''
select @sql=@sql+' kill '+cast(spid as varchar)+';' from master..sysprocesses where dbid=db_id(@dbname);
set @sql=@sql+'alter database '+@dbname+' set read_committed_snapshot on ' ;

exec(@sql);