通过下面的语句分析产生锁的语句,进而修复语句。其实根本原因还是在sql语句上。
DBCC OPENTRAN
GO
SELECT st.text,t2.* FROM sys.dm_exec_sessions AS t2,sys.dm_exec_connections AS t1
CROSS APPLY sys.dm_exec_sql_text(t1.most_recent_sql_handle) AS st
WHERE t1.session_id = t2.session_id
AND t1.session_id=‘进程号’