这种解决治标不治本。临时解决:--查看堵塞事务或者打开的事务
select * from sys.sysprocesses where open_tran > 0
select * from sys.sysprocesses where blocked > 0-- blocked > 0 可以kill
kill spid
还是要治本:
begin try
begin tran
select * from AAA
.....
commit tran
end try
begin catch
rollback tran
end catch
select * from sys.sysprocesses where open_tran > 0
select * from sys.sysprocesses where blocked > 0-- blocked > 0 可以kill
kill spid
还是要治本:
begin try
begin tran
select * from AAA
.....
commit tran
end try
begin catch
rollback tran
end catch
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货