Re: Log of Logins/Logouts
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 06/27/03
- Next message: Mandar Naik[MSFT]: "Re: IIS and SQL Server on different machines: how to connect with windows security"
- Previous message: Paolo C.: "IIS and SQL Server on different machines: how to connect with windows security"
- In reply to: Len: "Log of Logins/Logouts"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Mandar Naik[MSFT]: "Re: IIS and SQL Server on different machines: how to connect with windows security"
- Previous message: Paolo C.: "IIS and SQL Server on different machines: how to connect with windows security"
- In reply to: Len: "Log of Logins/Logouts"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
