[dba-SQLServer] See who has logged on

Darren DICK darrend at nimble.com.au
Mon Aug 28 07:50:34 CDT 2006


Hi All
 
Is it possible to find out who has logged on over a period of time into our SQL
Server?
 
I know I can use EntManager to look into Management|Current Activity|Process
info
 
And that will tell me 'who is on' at that given moment by logonname (User) or by
machine name (Host)
 
But is there a way I can interrogate some log or some table via say...Query
Analyser or by some other method - Just so I can see the same information as
"Process Info" gives me but in an archive kind of way?
 
Many thanks
 
Have a great day y'all
 
Darren



More information about the dba-SQLServer mailing list