• 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 ...