select spid, blocked, status, hostname, program_name, hostprocess, cmd 
from sysprocesses 
where dbid = db_id('xxx') and blocked > 0 

-- kill spid_xxx