Re: How to log the SQL Server actvities.....

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 02/14/04 

Date: Sat, 14 Feb 2004 17:31:58 +0530

Hi,

If it is just to verify the Successful and Failed Login attempts to server ,
then you can enable the Audit Level.

In Enterprise manager -- Right click above server and select properties --
In the security option -- You can set audit level to ALL and Apply.

After this you need to restart SQL server service. This will log all the
Successful and failed Login attempts in your SQL Server error log file.

Thanks
Hari
MCDBA

"Gary Smith" <GSmith72@yahoo.com> wrote in message
news:e4KRCft8DHA.2796@TK2MSFTNGP09.phx.gbl...
> How to log the SQL server logins ?
> I am using SQL Server 2000.
> Thanks
>
>