Re: Tracing sql server user logins
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/31/02
- Next message: Kirk Peterson: "NEWBIE: Error on SQL 7 after upg. to SP4"
- Previous message: Manuel: "Tracing sql server user logins"
- In reply to: Manuel: "Tracing sql server user logins"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Wed, 31 Jul 2002 12:58:48 -0600
Actually updatedate in syslogins is used to record the last
time the login was changed - such as changed password for
SQL Logins, changed default database, etc. It doesn't record
the last login.
-Sue
On Wed, 31 Jul 2002 11:19:14 -0700, "Manuel"
<manueljg@hotmail.com> wrote:
>Neil,
>
>It is not too late, query the Syslogins table in Master,
>look for the column UPDATEDATE, this is the one you're
>looking for, SQL Server logs the last time your user
>accessed the server. However, it will not reflect if the
>user is logged on at time you performing the query.
>
>hope this is waht you need.
>
>M
- Next message: Kirk Peterson: "NEWBIE: Error on SQL 7 after upg. to SP4"
- Previous message: Manuel: "Tracing sql server user logins"
- In reply to: Manuel: "Tracing sql server user logins"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
