checking for last time a SQL 2000 user logged in?

Hi,
Is there a way to tell the last time a given user logged into a SQL 2000
Server?
thanks,
Joeyou could query sysprocesses and look at the login_time for the user
such as select login_time from sysprocesses where loginame = 'the logged on
user'
"Joe" <JoeD777@.lycos.com> wrote in message
news:ugshww4YEHA.2432@.tk2msftngp13.phx.gbl...
> Hi,
> Is there a way to tell the last time a given user logged into a SQL
2000
> Server?
> thanks,
> Joe
>|||Thanks Hassan but, that isn't really what I was looking for. Lets say I have
a user or two, who I don't have logged on in six months. Is there a system
table that I can query to see if it really has been six months since a users
last logon to my SQL Server?
I have an number of development databases/users and I want to stay on top of
old, unused accounts.
Thanks,
Joe
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eBfpT$4YEHA.3432@.TK2MSFTNGP10.phx.gbl...
> you could query sysprocesses and look at the login_time for the user
> such as select login_time from sysprocesses where loginame = 'the logged
on
> user'
>
> "Joe" <JoeD777@.lycos.com> wrote in message
> news:ugshww4YEHA.2432@.tk2msftngp13.phx.gbl...
> 2000
>|||Trickier, it is possible to set login auditing to all which will record all
successful and unsuccesful logins however this does have a tendency to fill
up the SQL errorlog and the NT Application log. Either that or some kind of
trace that runs everyday, loads into a table from which you extract the
login counts and then restarts itself (you need to stop the trace to load it
into a table)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Joe" <JoeD777@.lycos.com> wrote in message
news:uGXTrI5YEHA.3304@.TK2MSFTNGP09.phx.gbl...
> Thanks Hassan but, that isn't really what I was looking for. Lets say I
have
> a user or two, who I don't have logged on in six months. Is there a system
> table that I can query to see if it really has been six months since a
users
> last logon to my SQL Server?
> I have an number of development databases/users and I want to stay on top
of
> old, unused accounts.
> Thanks,
> Joe
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:eBfpT$4YEHA.3432@.TK2MSFTNGP10.phx.gbl...
> on
SQL[vbcol=seagreen]
>