sp_who2

Stored procedure that shows all currently running processes.

sp_who2

BlkBy shows if and by who a table is being blocked by.

SPID can be used to identify what query is running.

DBCC INPUTBUFFER

You can kill SPID via

kill