Deadlock reported by server, connection=0101e24180032d28 code example

Example 1: t sql check active deadlock

select * from sys.sysprocesses where blocked > 0

Example 2: mssql find deadlocks

--[status]
EXEC sp_whoisActive;