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
    Moderator
    SQL-Server-Performance.com

    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
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page