Re: Question on C2 Log

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 10/13/04


Date: Wed, 13 Oct 2004 09:08:39 GMT

Hi Boon,

We use c2 audit mode option to review both successful and unsuccessful
attempts to access statements and objects instead of the whole process of
whatever operation had been done on SQL Server. With this c2 audit log
information, you can document system activity and look for security policy
violations.

Based on my scope, SQL Server has no such kind of funcationality to provide
a "flight recorder" log, however, some third party tools, such as Log
Explorer for SQL Server (http://www.lumigent.com/) might realized it.

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
 

Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.



Relevant Pages

  • Re: Multiple Instance cluster
    ... Introduction to Microsoft SQL Server 2000 Clustering ... Installation order for SQL Server 2000 Enterprise Edition on Microsoft ... Online Partner Support Specialist ...
    (microsoft.public.sqlserver.server)
  • Re: Multiple Instance cluster
    ... Introduction to Microsoft SQL Server 2000 Clustering ... > Installation order for SQL Server 2000 Enterprise Edition on Microsoft ... > Online Partner Support Specialist ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Server attacking UDP 1434
    ... I misunderstood, please feel free to let me know. ... targets the systems running Microsoft SQL Server 2000, ... SQL Server Resolution Service Port. ... Online Partner Support Specialist ...
    (microsoft.public.sqlserver.server)
  • RE: Log shipping
    ... it won't ask a recreation of Log Shipping after you have ... after your SQL Server services stopped and then restarted next night. ... Online Partner Support Specialist ... Microsoft is providing this information as a convenience to you. ...
    (microsoft.public.sqlserver.tools)
  • Critical Alert Update - W32.Slammer
    ... It's not clear if SQL Server 2000 SP1/SP2 includes the ... Microsoft SQL Desktop ... and all applications that install ... >most recent cumulative SQL Server security patch, ...
    (microsoft.public.security)

Quantcast