Current Activity/Process Info sorting

• bj007

  SSCommitted

  Points: 1928

  More actions

  June 20, 2003 at 2:26 pm

  #357919

  In EM / Management/ Current Activity/Process Info, I am trying to sort it on Login time. It looks like it is taking it as a character string and sorting it, and not by date sorting. Any idea? thanks for your help.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  June 20, 2003 at 3:18 pm

  #462474

  This data is mostly from sysprocesses with joins to syslogins, etc.

  You could get it from QA and then sort it.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net