sql server 死锁解决

sql server 死锁解决

SELECT name, is_read_committed_snapshot_on FROM sys.databases WHERE name = 'dbosql';

is_read_committed_snapshot_on 必须等于true; 如果不是，关闭所有连接数据库的应用，执行：

USE dbosql;
ALTER DATABASE dbosql SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE dbosql SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE dbosql SET MULTI_USER;