Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Audit Login & Logouts

Author  Topic 

kappa02
Yak Posting Veteran

65 Posts

Posted - 2006-09-06 : 14:16:17
Does anyone has a script that will keep track of when users login in or logout as well provide the date, I know you can use Profiler but you don't get the date just the duration.

Westley
Posting Yak Master

229 Posts

Posted - 2006-09-07 : 00:09:20
Hi,
Think profiler trace does give you the start and end time, you will just need to include them in the trace? you can also use a serve-side trace to do it, then import it back to SQL, thats how I'm doing it anyway, maybe there are some better ways from others?
Go to Top of Page
   

- Advertisement -