Transaction (Process ID) was deadlocked on lock - find and kill process

find-and-kill.sql

CREATE TABLE #Result  
(
  spid int,
  ecid int,
  status varchar(max),
  loginname varchar(max),
  hostname varchar(max),
  blk varchar(max),
  dbname varchar(max),
  cmd varchar(max),
  request_id int
)
INSERT #Result EXEC sp_who  
SELECT * FROM #Result WHERE dbname LIKE '%XXX%'  
DROP TABLE #Result  

-- Once you know the SPID you can run

KILL 28 -- or whatever the SPID is