Tell me more ×
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. It's 100% free, no registration required.
up vote 1 down vote favorite

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
4  
Isn't that what the @output_column_list optional parameter is for? This works for me: EXEC dbo.sp_WhoIsActive @output_column_list = '[dd%][session_id][database_name][sql_text][sql_command][login_name][wait_info][‌​tasks][tran_log%][cpu%][temp%][block%][reads%][writes%][context%][physical%][quer‌​y_plan][locks][%]' – Paul White Feb 9 at 6:43
yes that was the fix.... thank you very much – Rizwan Hassan Feb 9 at 7:59

2 Answers

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
+1 saw this after I added my comment on the question. – Paul White Feb 9 at 6:45
Thanks Guys.. let me give it a try and get back to you... – Rizwan Hassan Feb 9 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 Hassan Feb 9 at 8:00
up vote -3 down vote

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 Hassan Feb 9 at 3:51

Your Answer

 
discard

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.