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