Log of Logins/Logouts

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

Date: Fri, 27 Jun 2003 02:39:36 -0700

Apologies - this post should be a reply for an earlier
post - see below.

Len.

Subject: Re: Log of Logins/Logouts
 From: "Dejan Sarka"
<dejan_please_reply_to_newsgroups.sarka@avtenta.si> Sent:
6/26/2003 11:34:47 PM
 

 

Len,

More detailed info can be audited using the Profiler.
Check the "Monitoring
with SQL Profiler" part in Books OnLine
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%
20Server\80\Tools\Books\ad
minsql.chm::/ad_mon_perf_86ib.htm). 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Len" <lenny3k@hotmail.com> wrote in message
news:090301c33c01$517e9570$a001280a@phx.gbl...
> Hi there.
>
> I am looking for a way to log details of all
> logins/logouts for an SQL 2000 Server. So far, I've come
> across using the 'Security' tab in the
> database 'properties' dialog (Enterprise Mgr - right-
click
> on the database..) to enable "Audit ALL".
>
> This allows me to view logins & logouts in the Server 
logs
> (under the 'Management' tree). Unfortunately, I can't get
> enough information from this:
>
> -The log records only show a user name for the events - I
> don't know how to find out how the IPAddress or any more
> information on the login.
>
> Any ideas where I might find such info?
>
> Basically, user name isn't enough to identify 
applications
> for me because the applications I'm looking for all use
> the same one.
>
> Any help would be appreciated!
>
> (I'm new at this btw!...)
>
> Len.
.

Relevant Pages

  • Re: Multiple Quesions and some feedback on Modelling
    ... need to add ENV is sql server 2005 enterprise edition. ... Have a model structure that entails three mining models including tree. ... >> was they are trained already for sql management studio because otherwise ... > Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Re: Multi Dimensional Cases in Time Series
    ... This message does not imply endorsement from Solid Quality Learning, ... >> - in SQL Server, create a linked server to the Analysis Services ... >> Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.datamining)
  • Re: SQL7 standalone
    ... Can you connect with Query Analyzer using a SQL login (SQL authentication)? ... Dejan Sarka, SQL Server MVP ... "giovanni" wrote in message ... I thought you mean SQL Server installed on the ME. ...
    (microsoft.public.sqlserver.server)
  • Re: Shrinking or reseting log file
    ... Dejan Sarka, SQL Server MVP ... > It seems that two databases are using the same log file ... >> Dejan Sarka, SQL Server MVP ... >> Solid Quality Learning ...
    (microsoft.public.sqlserver.programming)