For Sql Server DBAs, sp_who is an indispensable diagnostic tool for researching, monitoring, and troubleshooting. For example, you can use it to iterate through all sessions to a particular database, logins used, and host name where a session is initiated from, etc.. sp_who is modified slightly in Sql Server 2005. It now returns one additional…