[dba-SQLServer] Last Login?

That was IT!
Thanks!!!


On Fri, 5 Nov 2004 13:19:12 -0500, Francis Harvey <harveyf1 at westat.com> wrote:
> 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
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
<a href="http://pcthis.blogspot.com">Pc This! pc news with out the jargon</a>