How can I get the last login date for a login ??

How can I get the last login date for a login '
Thx
JohnnyThis information is not tracked by default. You could capture it using SQL
Profiler and output the information to a SQL table, or create your own
triggers on user tables to track this.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Take a look at the login_time column of
master.dbo.sysprocesses.
Linchi

quote:

---

>--Original Message--
>How can I get the last login date for a login '
>Thx
>Johnny
>.
>

---

|||You could also set login auditing to All and query the SQL errorlog where
all the logins are recorded
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Johnny Silvestre" <johnny_silvestre@.yahoo.de> wrote in message
news:01e401c3d549$ca9d9640$a301280a@.phx.gbl...

quote:

---

> How can I get the last login date for a login '
> Thx
> Johnny

---

|||hi Johnny ,
This is not tracked by default.You have to do some settings for that. SQL
Server can log event information for logon attempts and you can view it by
reviewing the errorlog. By turning on the auditing level of SQL Server.
follow these steps to enable auditing of all/successful connections with
Enterprise Manager in SQL Server:
Expand a server group.
Right-click a server, and then click Properties.
On the Security tab, under Audit Level, click all/success etc(required
option).
You must stop and restart the server for this setting to take effect.
-- Vishal|||Oops! Thought you wanted the login date of a spid.
Linchi

quote:

---

>--Original Message--
>Take a look at the login_time column of
>master.dbo.sysprocesses.
>Linchi
>
>.
>

---