Subhash Chandra over at Sql Server Central has written what appears to be a great little procedure for granting someone the ability to run sp_who and sp_who2 without granting them sysadmin privileges.
Grat sp_who2 & who3 without granting sysadmin privileges
I have literally nothing to add :-D Posting it here mostly so I can easily find it later. Thanks, Subhash.
