sp_who2 active
sp_lock 76
select object_name(261575970,16)
select %%lockres%%,* from SessionLock(nolock) --from reporttempdb
select * from SessionData where SessionID='scaszk45rrhlqureb1pvbp45'
kill 71
本文共 251 字，大约阅读时间需要 1 分钟。
sp_who2 active
sp_lock 76
select object_name(261575970,16)
select %%lockres%%,* from SessionLock(nolock) --from reporttempdb
select * from SessionData where SessionID='scaszk45rrhlqureb1pvbp45'
kill 71
转载于:https://www.cnblogs.com/hqbird/p/3956639.html