Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
yes that was the fix.... thank you very much – Rizwan Feb 9 '13 at 7:59
up vote 3 down vote accepted

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.

share|improve this answer
Thanks Guys.. let me give it a try and get back to you... – Rizwan Feb 9 '13 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 '13 at 8:00

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

share|improve this answer
I played with it but couldn't make any progress... I have asked him too but most probably he is busy – Rizwan Feb 9 '13 at 3:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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