Auditing

From: Steve (steve.m.alves@saic.com)
Date: 10/01/02


From: "Steve" <steve.m.alves@saic.com>
Date: Mon, 30 Sep 2002 16:43:40 -0700


In Enterprise Manager right click on the server name then
select > Properties > Security tab > In the Audit Level
section select "All".

If your interested in setting up trace file/tables for
more detailed audit tracking email me.

Steve

>-----Original Message-----
>I'm trying to create auditing to track user
logon/logoff.
>How do I use system stored procedures or Profiler to
>create the trace and have it to start automatically
>whenever SQL starts?
>.
>



Relevant Pages

  • Re: Audit Log in Yukon
    ... Do you mean the Audit Level server setting that writes entries to the SQL ... Error Log? ...
    (microsoft.public.sqlserver.tools)
  • RE: Remove user login audit from SQL Server Error log
    ... Right click on your server in EM and choose properties. ... Sounds like your Audit level is either all or success. ... > I have an issue with the SQL Server Error Logs for my SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: How to log the SQL Server actvities.....
    ... In the security option -- You can set audit level to ALL and Apply. ... After this you need to restart SQL server service. ... Successful and failed Login attempts in your SQL Server error log file. ...
    (microsoft.public.sqlserver.setup)