?
Solved

Capture login and logout time in SQL 2000

Posted on 2005-04-29
5
Medium Priority
?
281 Views
Last Modified: 2008-03-10
Is there away to determine when a user logged into and out of a SQL Database?
0
Comment
Question by:mobot
  • 3
5 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 13898251
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....
0
 
LVL 34

Expert Comment

by:arbert
ID: 13898273
Enterprise Manager, right click on your server, properties, security tab.  Enable the logging...
0
 

Author Comment

by:mobot
ID: 13898485
I check the setting I see audit level setting but nothing that says enable logging for log-in and log-out options.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 13898570
>>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
0
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 13898869
:)
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
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.

864 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