sql server关闭存储过程中未提交的事务
【1】select * from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id = (
【2】查询出来的id
)
【2】DB_ID()
【3】DBCC OPENTRAN;
【4】kill (【3】查询出来的id)
【1】select * from sys.dm_tran_locks where resource_type = 'OBJECT' and resource_database_id = (
【2】查询出来的id
)
【2】DB_ID()
【3】DBCC OPENTRAN;
【4】kill (【3】查询出来的id)