|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
finding out the last login
Hi ,
Is there any table in SQL that actually tracks when is the last login for a particular user ? appreciate ur advise tks & rdgs Hi
I use SQL Server Profiler to track such info "maxzsim via SQLMonster.com" <u14644@uwe> wrote in message news:5d6117586b7ab@uwe...Show quoteHide quote > Hi , > > Is there any table in SQL that actually tracks when is the last login for > a > particular user ? > > appreciate ur advise > > tks & rdgs > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1 Depending on your tracing level your could also write successfull or
failed logins to the event log, and reading from this. IMHO, Profiler is a but heavy for a continuous tracking of logins. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- tks but i am afraid that profiler is very cpu-intensive
Jens wrote: Show quoteHide quote >Depending on your tracing level your could also write successfull or >failed logins to the event log, and reading from this. IMHO, Profiler >is a but heavy for a continuous tracking of logins. > >HTH, Jens Suessmeyer. > >--- >http://www.sqlserver2005.de >---  
Other interesting topics
Stop & Start SQL Server for using scm
expectations for SUM query on 50+ million rows Internal SQL Server error Trusted Connection failing Move 2000 to 2005 Memory allocation in MS-SQL 2000 instances Windows says SQL is installed, but it's not! Why do Ado.net don't use execution plan that Query Analyzer Query suddenly becomes very slow Page coruption |
|||||||||||||||||||||||
