I really like using sp_whoisactive v11.11 by Adam Machanic. But when then info is displayed, the DB name is at the very end. I would like it to in the very first columns so I don't have to scroll everytime... Does anyone have suggestions to arrange columns


2 Answers 2


Edit the line with @output_column_list declared on it and put [database_name] between [dd%] and [session_id].

When I scripted it out it was on line 110.

  • Thanks Guys.. let me give it a try and get back to you...
    – Rizwan
    Feb 9, 2013 at 7:51
  • Thank you for helping me mrdenny and SQL Kiwi... appreciate taking your time to assist. I was going through the whole code and tweeking different parts of the code except for line 110.
    – Rizwan
    Feb 9, 2013 at 8:00

Change the code. Or ask Adam Machanic to change it.

  • I played with it but couldn't make any progress... I have asked him too but most probably he is busy
    – Rizwan
    Feb 9, 2013 at 3:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.