I have always wanted Microsoft to incorporate an ability to see who are the active users and the complete sql they are running as Oracle enterprise manager lets you do(more information than sp_who2 provides)

Mike