t sql check active deadlock

select * from sys.sysprocesses where blocked > 0