Log of Logins/Logouts

From: Len (lenny3k_at_hotmail.com)
Date: 06/27/03 

Date: Fri, 27 Jun 2003 02:16:03 -0700

Thanks Dejan - that provides just the information I need.

One more question though: I wish to configure a trace to
just log logins/logouts on a server over a long period of
time (months at least)-
Is using SQL Profiler suitable for this?
I can configure the trace to log the data in a file using
rollover. Are there any issues of concern in using SQL
Profiler to achieve this? (Other than having to manually
restart the trace each time SQL Server is restarted)

Can I assume that if I'm only logging logins & logouts
that performance won't be a big issue?

Len

Relevant Pages

  • Re: User and Login auditing
    ... I agree 100% with Sue on not touching the system tables. ... > and hope that your employer doesn't mind you putting the SQL ... > Server box in this position. ... You could put triggers on your trace table. ...
    (microsoft.public.sqlserver.security)
  • Re: Problem with SQL Server [Solution]
    ... Apparently my sql server was not set to mixed mode authentication. ... > with the Trace Properties. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: URGENT deadlock question
    ... I have a deadlock template that I use with the following ... > SQL: Statement Completed ... > "Trace flags remain enabled in the server until disabled by executing ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 7 Traces
    ... Profiler 2K can generate the xp calls for a defined trace in 7 format. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 7 Traces
    ... With SQL 7, you can simply use the SQL Profiler to trace the server. ... Profiler is a GUI tool that hooks into server events inside SQL Server. ...
    (microsoft.public.sqlserver.programming)