[dba-SQLServer] Last Login?

Francisco,

Maybe something like:

select top 1 loginame, login_time
from master.dbo.sysprocesses
order by login_time desc

Francis R Harvey III
WB 303, (301)294-3952
harveyf1 at westat.com


> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Francisco Tapia
> Sent: Friday, November 05, 2004 12:40 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] Last Login?
> 
> 
> I'd like to use this for my FE app, that is return the "last login"
> information.  However I'm not having any luck w/ my keywords in BOL
> 
> any hints are appreciated :D 
> -- 
> -Francisco
> <a href="http://pcthis.blogspot.com">Pc This! pc news with 
> out the jargon</a>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>