[dba-SQLServer] See who has logged on

Hi Darren,

Seems you need to set the audit level (none by default) in the server
properties tab,
under security.
You then need to use profiler to keep track of the events you want to
trace.
ie logon, logout, logon failure etc...

Never done it myself but BOL has the answers, look under audit.

cheers 


Michael M


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Darren
DICK
Sent: Monday, 28 August 2006 10:51 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] See who has logged on

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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com