SQL Server Performance

Audit Logins/Logouts

Discussion in 'General DBA Questions' started by nupe02, Sep 6, 2006.

  1. nupe02 New Member

    Does anyone has a script that will keep track of when users login in or logout as well provide the date, I know you can use Profiler but I don't think you can get a date just duration.[?]
  2. Luis Martin Moderator

    I can't follow you.
    With profiler you can get starttime and endtime.
    Can you explain a litle more, please.

    Luis Martin

    All in Love is Fair
    Stevie Wonder

    All postings are provided “AS IS” with no warranties for accuracy.

  3. satya Moderator

    You can store the trace to a table and then calculate the columns for the preferred results.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page