"Adam Sankey" wrote:

> Is it possible to produce a report of when each login last logged in to a
> server?
>
> Thanks
> Adam

"Peter Nolan" wrote:

> Not directly no, but there are a couple of things you can have a look at.
>
> Firstly you can track all log on and attempts at log on in your SQL Server
> log file. To do that right click on Server, select Security, and under Audit
> select 'All', this will log both succuessful, and unsuccessful attempts. You
> will need to start and stop the Service however.
>
> If you want a bit more of a solution closer to what you want, I know where
> you can start looking, but you will have to do a bit of research on how to do
> it yourself.
>
> Under SQL Server Alerts you can get SQL Server to perform an action based
> upon a internal message. For instance I have it to send me an email whenever
> an illegal log in is performed, you could have a look at doing that, but in
> your case run a job afterwards to add / modify the date of the log in a table.
>
> They maybe another way using the sysprocesses table in the master database
> by running a job, but you may want to look into doing that yourself.
>
> Peter
>
> "Adam Sankey" wrote:
>
> > Is it possible to produce a report of when each login last logged in to a
> > server?
> >
> > Thanks
> > Adam

"bing" wrote:

> Hi Peter,
>
> When I selected Security in EM,  I don't see Audit.  Do I need to turn on
> some option to see it?   This is SQL 2000 on a win2k3 box.
>
> Thanks, 
>
> Bing
>
> "Peter Nolan" wrote:
>
> > Not directly no, but there are a couple of things you can have a look at.
> >
> > Firstly you can track all log on and attempts at log on in your SQL Server
> > log file. To do that right click on Server, select Security, and under Audit
> > select 'All', this will log both succuessful, and unsuccessful attempts. You
> > will need to start and stop the Service however.
> >
> > If you want a bit more of a solution closer to what you want, I know where
> > you can start looking, but you will have to do a bit of research on how to do
> > it yourself.
> >
> > Under SQL Server Alerts you can get SQL Server to perform an action based
> > upon a internal message. For instance I have it to send me an email whenever
> > an illegal log in is performed, you could have a look at doing that, but in
> > your case run a job afterwards to add / modify the date of the log in a table.
> >
> > They maybe another way using the sysprocesses table in the master database
> > by running a job, but you may want to look into doing that yourself.
> >
> > Peter
> >
> > "Adam Sankey" wrote:
> >
> > > Is it possible to produce a report of when each login last logged in to a
> > > server?
> > >
> > > Thanks
> > > Adam