sql server2008 表发生了死锁

SELECT
r.session_id AS blocking_session_id,
r.wait_type,
r.wait_time,
r.wait_resource,
s.host_name,
s.login_name,
r.status,
r.command,
r.database_id
FROM
sys.dm_exec_requests r
JOIN
sys.dm_exec_sessions s ON r.session_id = s.session_id
WHERE
r.blocking_session_id <> 0;


SELECT * FROM sys.dm_exec_sessions WHERE session_id = 52


DECLARE @SessionID INT;
SET @SessionID = 52; --替换为实际的block session id

-- 强制终止该进程
IF EXISTS (SELECT * FROM sys.dm_exec_sessions WHERE session_id = @SessionID)
BEGIN
KILL 52;
PRINT 'Session ' + CAST(@SessionID AS NVARCHAR(10)) + ' has been terminated.';
END
ELSE
BEGIN
PRINT 'Session does not exist.';
END