Welsh Corgi (3/28/2015)
Lowell,I have googled and googled.
I can't find one.
Do you have a link to one that works?
Thanks.
First result I got was A Better sp_who2 using DMVs (sp_who3)
😎
On the tin it says:
The following code generates the same information found in sp_who2, along with some additional troubleshooting information. It also contains the SQL Statement being run, so instead of having to execute a separate DBCC INPUTBUFFER, the statement being executed is shown in the results.
Unlike sp_who2, this custom sp_who3 only shows sessions that have a current executing request.