Re: Log of Logins/Logouts

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 06/27/03 

Date: Fri, 27 Jun 2003 11:14:37 +0100

If that's all you're monitoring using a server side trace to a
file then you won't notice it. You can set up a job to start
a trace each day, loading the previous day's file into a table
using fn_trace_gettable and then deleting it. This will allow
you to more easily query it on an adhoc basis or to generate
activeity reports. 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Len" <lenny3k@hotmail.com> wrote in message
news:089601c33c8c$bb92bd70$a501280a@phx.gbl...
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: URGENT deadlock question
    ... >> network to the Profiler client, but there is no guarantee you'll see ... >> everything if SQL Server doesn't feel like it can keep up with all ... Just make sure the trace file is created on a local ...
    (microsoft.public.sqlserver.server)
  • Re: Ado.net DataSet Refresh
    ... I would like to suggest you use SQL profile to trace server. ... SQL server 2005 express edition doesn't have SQL Server Profile. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... I always start with a light trace and add more detail as I go along to ... SQL Server MVP ... > I think it's also worth saying that you should introduce Profiler ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Repost - Unable to authenticate a VPN
    ... Thanks I did get the trace.. ... Microsoft Small Business Server Support ... >> the connection manager client.. ...
    (microsoft.public.windows.server.sbs)
  • Re: URGENT deadlock question
    ... > Profiler to view a trace, SQL Server dumps rowsets across the network to ... > SQL Server doesn't feel like it can keep up with all the activity. ... > server-side trace to a trace file guarantees you'll see everything. ...
    (microsoft.public.sqlserver.server)