Works great! One problem though. I'm running on SQL2008 but I don't see everything returned back when I run exec sp_who5 'O?' for displaying all the output columns. I only receive a partial list (below) It just stops with .... on Database_Name. Any idea why?
Msg 50000, Level 16, State 1, Procedure usp_who5, Line 107
Output:
SPECID : System Process ID with Execution Context ID
Blocked : Blocking indicator (includes type of block and blocking SPID)
Running : Indicates if SPID is currently executing, waiting, inactive, or has open transactions
Login_ID : Displays Windows user name (or login name if user name is unavailable)
Login_Name : Full name of the user associated to the Login_ID (if available)
Elapsed_Time : Total elapsed time since the request began (HH:MM:SS)
CPU_Total : Cumulative CPU time since login (HH:MM:SS)
CPU_Current : Cumulative CPU time for current process (HH:MM:SS)
Logical_Reads : Number of logical reads performed by current process
Physical_Reads : Number of physical reads performed by current process
Writes : Number of writes performed by current process
Pages_Used : Number of pages in the procedure cache currently allocated to the process
Nesting_Level : Nesting level of the statement currently executing
Open_Trans : Number of open transactions for the process
Wait_Time : Current wait time (HH:MM:SS)
Wait_Type : Current wait type
Last_Wait_Type : Previous wait type
Status : Status of the current process
Command : Command currently being executed
SQL_Statement : SQL statement of the associated SPID
Query_Plan_XML : Execution plan (XML)
Since_SPID_Login : Total elapsed time since client login (HH:MM:SS)
Since_Last_Batch : Total elapsed time since client last completed a remote stored procedure call or an EXECUTE statement (HH:MM:SS)
Workstation_Name : Workstation name
Database_Name ...