Re:Auditing SQL Server

From: Vishal Parkar (vgparkar_at_hotmail.com)
Date: 04/28/03


Date: Mon, 28 Apr 2003 07:54:06 -0700


To audit Login and Logout make use of SQL Profiler.
Capture events "audit login"/"audit logouts" under
event "security audit"

--Vishal

>-----Original Message-----
>We have over 40 SQL machines here, most with 2000, some
on 7. Due to
>new HIPAA regulations, we're going to have to audit all
accounts on
>all servers from time to time. I'm wondering if there's
some kind of
>magical tool that will allow me to do this. All help
appreciated.
>
>Thanks,
>Steve
>.
>



Relevant Pages

  • Logging of login and logout
    ... Does anyone know if there is a way to take log (or audit) who has login to ... the AD and logout of it? ... Thnaks. ...
    (microsoft.public.win2000.active_directory)
  • Re: Log of user activity
    ... Use the profiler and do below to audit the login and logout for a specific ...
    (microsoft.public.sqlserver.security)