• Here's a caveat you can add to running sp_who2 to get just the running processes.

    exec sp_who2 active