DBCC INPUTBUFFER

Allows you to see by SPID what queries are currently running.

DBCC INPUTBUFFER(63) -- arg is SPID