When deadlock happen using this quires. i found the user and kill that session

Kill session

 –FIND KILLING SPID
SELECT
hostname,*
— net_library,
— net_address,
— client_net_address

FROM sys.sysprocesses AS S
INNER JOIN sys.dm_exec_connections AS decc ON S.spid = decc.session_id
WHERE S.open_tran=1
–WHERE spid = @@SPID –this query only check your session if hide its check all –session
–KILL 60

 

 

Advertisements