Re: C2 auditing

From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
Date: 07/16/03


Date: Tue, 15 Jul 2003 23:36:16 -0400


There's a section in BOL (books online) that explains C2 auditing and how to
enable it.
I cut and pasted the url in bol from my pc:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adm
insql.chm::/ad_config_09yd.htm

-- 
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Ram" <mail_info@rediffmail.com> wrote in message
news:044401c34b38$5c229d50$a601280a@phx.gbl...
> Hi ,
>
> how to setup c2 auditing. I want to track deletion on
> tables, which login / user delete data from some tables.
> how can I do it. how to configure c2 auditing. If I set
> sp_configure c2 audit mode to 1 what it means, will server
> start auditing activities
>
> can't find much doc on c2 auditing. checked
> C2 'Administrator's and User's Security Guide' dont have
> much on c2 auditing. like how to track activities of
> particular logins / activities on tables , I know I can do
> it through profiler, but I dont want to run trace all the
> time.
>
> can I do it other way ( c2 auditing?)
>
> please let me know.
>
> appreciate your reply .
>
> -Ram


Relevant Pages

  • Re: Full Text Indexing on Microsoft SQL Server 2000 with Windows XP Pro
    ... I went in there and I found the Auditing level set to None which ... > Editions of SQL Server 2000"). ... >> I am not seeing any unusual messages in the Event Viewer also. ...
    (microsoft.public.sqlserver.programming)
  • Re: Tracing sql server user logins
    ... Now for your question: base auditing ... > GroupName sysname NULL, ... SQL Server does not audit by ... >>Failure causes only failed login attempts to be audited. ...
    (microsoft.public.sqlserver.security)
  • Re: Question on C2 Log
    ... I am now analyzing the trace, ... >> auditing all logins no matter it is successfully or failed? ... >> Audit Level you wanted. ... click SQL Server and Windows. ...
    (microsoft.public.sqlserver.security)
  • Re: failed login attempts
    ... The Hostname of the client computer is captured (for sure in ... You can indeed turn on failed login auditing via a ... You can also capture this information with ... Microsoft SQL Server doesn't have built-in failed logins ...
    (microsoft.public.sqlserver.security)
  • RE: SQL Worm
    ... You may want to enabling login auditing in SQL Server. ... Also to identify the culprit process/workstation you can use the ...
    (microsoft.public.sqlserver.security)