Log

How do I configure the SQL Server 2000 to keep a log of all attempts to log
in regardless success or failure ?"Pak Tse" <pak_tse@.optusnet.com.au> wrote in message
news:3f362f00$0$10358$afc38c87@.news.optusnet.com.a u...
> How do I configure the SQL Server 2000 to keep a log of all attempts to
log
> in regardless success or failure ?

In Enterprise Manager, right-click the server and choose Properties,
Security. Then select 'All' under Audit Level.

Simon|||Thank you.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:3f363d9e_4@.news.bluewin.ch...
> "Pak Tse" <pak_tse@.optusnet.com.au> wrote in message
> news:3f362f00$0$10358$afc38c87@.news.optusnet.com.a u...
> > How do I configure the SQL Server 2000 to keep a log of all attempts to
> log
> > in regardless success or failure ?
> In Enterprise Manager, right-click the server and choose Properties,
> Security. Then select 'All' under Audit Level.
> Simon