asked on

Any way to change sequence of columns in View History/Log File Viewer in SQL Server 2008?

We are testing SQL Server 2008 to move from 2000. When I review the history of SQL Agent jobs in 2008, the view shows many more fields than in 2000. The field I review the most is Duration. In 2000, you could see it without scrolling. In 2008, you have to scroll a lot to get to this field. I tried to modify the view and I was able to drag it farther to the left, but my changes weren't saved.

Can the history view be modified so that I can see the fields in the sequence that I want? I also want to move server name/instance name to the far right, along with a few other fields.

Thanks,
Alexis

Kevin Cross

The columns are dragable, so you can simply move it over to the left.

SOLUTION

santhimurthyd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Kevin Cross

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

alexisbr

ASKER

Thanks for your replies. As I said in my question, I have moved the columns around and I also have squeezed the columns together that I don't need. This works like any other datasheet/grid I have worked with. However, I don't want to have to set the columns each and every time I review job history. In SQL Server 2000, only a few columns were displayed, and one of them was Duration so I didn't have this problem before. I review Job History all the time and having to scroll over all the time to see the duration will be a huge pain. I'm surprised there's not a setting to allow you to select the columns you want to see, like you can in Outlook.

ASKER CERTIFIED SOLUTION

Kevin Cross

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kevin Cross

This may be a good start: http://www.sql-server-performance.com/2007/custom-reports-ssms/

alexisbr

ASKER

Thanks for your help.