locked
SSMS 2012 - Event Log Viewer RRS feed

  • Question

  • Hi All,

    Since I've been using the 2012 version of SQL Server Management Studio the Event Log Viewer orders the events by time in an ascending order. To my knowledge this used to be in a descending order. Does anyone know if this is a setting that can be changed?

    Kind Regards,

    Mark

    Friday, May 18, 2012 12:21 PM

Answers

  • So, I'm guessing this is just the way it is. Without a good explanation?


    Seems like a bug - you could create a Connect incident for it

    Chuck Pedretti | Magenic – North Region | magenic.com

    • Marked as answer by Stephanie Lv Monday, June 4, 2012 7:19 AM
    Tuesday, May 29, 2012 12:35 PM

All replies

  • I'm looking at my 2012 RTM instance right now and the logs display in decending order.


    Chuck

    Friday, May 18, 2012 12:49 PM
  • Hello Mark,

    Same here, the log is sort ascending by event date. But with a quik click on the column header the sort order changes to descanding.


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

    Friday, May 18, 2012 12:55 PM
  • Hello Mark,

    Same here, the log is sort ascending by event date. But with a quik click on the column header the sort order changes to descanding.


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

    What version of ssms are you guys seeing in the about box?  Mine is 11.0.2100.60

    Chuck

    Friday, May 18, 2012 1:04 PM
  • Hello Chuck,

    11.0.1750.32 = RC0, so it seems it has change in RTM.


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing

    • Proposed as answer by Stephanie Lv Monday, May 21, 2012 6:02 AM
    Friday, May 18, 2012 1:26 PM
  • I've got the same version.

    To make it more interesting, connecting to 2012 instance uses the 'correct' ordering, connecting to a lower version (2008 R2) uses the 'wrong' ordering.

    The arrow used to indicate the order is pointing downwards, suggesting large -> smaller


    • Edited by MVerbaas Friday, May 18, 2012 1:31 PM
    Friday, May 18, 2012 1:28 PM
  • I've got the same version.

    To make it more interesting, connecting to 2012 instance uses the 'correct' ordering, connecting to a lower version (2008 R2) uses the 'wrong' ordering.

    Just tried connecting to a SQL 2008R2 instance with my 2012 SSMS and I do see an Acending sort on those logs.   Kind of odd that the ASC/DESC changes based on the version of the DB you are connected to.

    The thing that is really odd is that the arrow indicates that it is sorted desc while the data is clearly ASC


    Chuck



    Friday, May 18, 2012 1:30 PM
  • Chuck,

    I've got the exact same behaviour.

    Regards,

    Mark

    Friday, May 18, 2012 1:33 PM
  • check this link this may help you

    http://msdn.microsoft.com/en-us/library/ms191008.aspx

    Saturday, May 19, 2012 10:22 AM
  • So, I'm guessing this is just the way it is. Without a good explanation?

    Tuesday, May 29, 2012 11:50 AM
  • So, I'm guessing this is just the way it is. Without a good explanation?


    Seems like a bug - you could create a Connect incident for it

    Chuck Pedretti | Magenic – North Region | magenic.com

    • Marked as answer by Stephanie Lv Monday, June 4, 2012 7:19 AM
    Tuesday, May 29, 2012 12:35 PM
  • All,

    This seems to be 'solved' in SQL Server 2012 Service Pack 1.

    Regards,

    Mark

    Friday, November 16, 2012 10:47 AM