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

  • yes that was the fix.... thank you very much – Rizwan Feb 9 '13 at 7:59

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

  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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