Run sp_who2, look in the blkby column and find the process that is at the start of a block chain. Identify its SPID. Then you can run "kill <SPID>" to kill the blocking transaction to see if that allows all others to execute.