auditing logins

SQL 2k, Windows authentication only
I'd like to be able to monitor when a particular developer attempts to
login to sql server. (successful or not)
Ideally, I'd like an alert to fire when that user logs in or attempts
and fails to log in. How can I set up an alert for successful login?
Is the auditing information stored in tables? I could schedule a job to
select for that developer every hour or so.
I know the log files are written to disk, so should I just write a small
program to search through these?
I appreciate any/all suggestions
Tom
--
E-mail correspondence to and from this address may be subject to the
North Carolina Public Records Law and may be disclosed to third parties.Login auditing is done in the Windows Security event log. There is an
option to set it for successful logins, failed logins or both.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tom W" <Tom.Williams@.DontSpamMencmail.net> wrote in message
news:ur3wDW12GHA.3516@.TK2MSFTNGP06.phx.gbl...
> SQL 2k, Windows authentication only
> I'd like to be able to monitor when a particular developer attempts to
> login to sql server. (successful or not)
> Ideally, I'd like an alert to fire when that user logs in or attempts and
> fails to log in. How can I set up an alert for successful login?
> Is the auditing information stored in tables? I could schedule a job to
> select for that developer every hour or so.
> I know the log files are written to disk, so should I just write a small
> program to search through these?
> I appreciate any/all suggestions
> Tom
> --
>
> E-mail correspondence to and from this address may be subject to the
> North Carolina Public Records Law and may be disclosed to third parties.