sql check deadlocks 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;