Capture login and logout time in SQL 2000

Posted on 2005-04-29
Last Modified: 2008-03-10
Is there away to determine when a user logged into and out of a SQL Database?
Question by:mobot
    LVL 34

    Expert Comment

    You can use SQL profiler, but it has to be running all the time.  Other than that, you would need to turn on the C2 auditing, or use windows authentication and log the login/logout events....
    LVL 34

    Expert Comment

    Enterprise Manager, right click on your server, properties, security tab.  Enable the logging...

    Author Comment

    I check the setting I see audit level setting but nothing that says enable logging for log-in and log-out options.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>I check the setting I see audit level setting but nothing that says enable logging for log-in and log-out options.<<
    Arbert missed the final step:
    Click the Help button and read up on the section under Audit
    LVL 34

    Accepted Solution


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now