• However why do we need to go to the maintenance plan's log? SQL Server includes the job history. It includes maintenance plans. Why doesn't the job understand there is a maintenance plan, read it's log, and return the information? Or give us a button on the job history that loads up the maintenance plan log? That's a simple thing to do, and isn't the job of software to make tasks easier?

    This sounds like a useful feature missing from the SQL Server Management Studio application, rather than the database engine or SQL Agent. Perhaps Microsoft has intentionally capped the investment on SSMS, implementing basic management functionality, thinking that 3rd party tool vendors or add-ins will fill in the gaps.

    Another feature missing from SSMS 2008/2012 out of the box, something that I consider to be basic, is information schema search. This was included in the old v2000 Query Analyzer. However, Red Gate's SQL Search add-in can be downloaded for free and is even better.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho