Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Find Each Logins Last Login Date

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2011-01-13 : 16:33:24
hi everyone,

In 2005, do any system tables or dynamic management views show the last login date for each user/login?

I do have login auditing enabled but that only generates entries into the SQL server log meaning I would have to muddle thru all the logs and do it for 100 users. Ouch.

Thanks, John

RobertKaucher
Posting Yak Master

169 Posts

Posted - 2011-01-13 : 21:10:36
I don't believe such a thing exists.

http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/11/10/sql-server-wish-last-logon-information.aspx

===
http://www.ElementalSQL.com/
Go to Top of Page
   

- Advertisement -