An easy way to improve the usability of
sp_who2 is to make a database specific version.
The idea is to leverage the information provided by
sp_who2, but provide a filter for a given database name. This is really handy on either production or development SQL servers with large numbers of databases.