t sql check active deadlock code example Example: t sql check active deadlock select * from sys.sysprocesses where blocked > 0