sp_who2 will run for all the databases.

If its specific to one database then you can try something like :-

select * from sysprocesses where dbid = yourdatabaseid(which you can get by select * from master.sys.databases)

Also you can further filter this select for blocked <>0 (for blocking queries) or waittime > 0(for long running queries) and further.