SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of K. Brian Kelley
Author:

Author Bio:
Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...
Enabling C2 Auditing in SQL Server

Enabling C2 Auditing in SQL Server

C2 auditing is used to make sure that no action can be performed without being captured to an audit trace file. In this video Brian show you how to enable C2 audit tracing and view the resulting files.

Video Information
Publish Date:
December 15, 2008
Length:
2:40
Skill Level:
100
Rating:
4.35 out of 5

After watching you should be able to answer these questions:
  1. How can you view C2 trace files

  2. Where will C2 trace files be stored on disk?
You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Steve on 3/25/2009
I think your video demonstrations are really great! Reading the books are fine, but learn so much more using video as you can see the theory in action.

B750460146 on 3/25/2009
more on how to control/add/remove tracepoints ?

Mark Horninger on 3/25/2009
Well done!

Mark Horninger on 3/25/2009
Would also be good to cover what is captured in the trace (events and cols)?

Steve Harris on 3/25/2009
Doesn't say why C2 auditing should/would be used. Also doesn't say in what way the trace could be used.

Dugi on 3/25/2009
very nice explanation here for C2 ...thnx Brian !

4F5430C3DD on 3/25/2009
Very useful and concise. Does not take a lot of time.

995751D667 on 3/25/2009
Explaining what Common Compliance auditing that replaced C2 audit;

Tom B. on 3/25/2009
Thanks. I am always interested in learning the extras when it comes to SQL Server. I will try this out.

Tom B. on 3/25/2009
I think the video is perfect, short and concise. The other topics need not be explained here, but in other videos. I think the key is to detail specific information so the user can understand that one point. Other topics related but not specific are target for coverage in other videos.

Richmond Platz on 3/25/2009
clear and precise, talk is a bit fast! No pun intended, LOL

Tony Knowling on 3/25/2009
Good vid, but wonder how huge the trace files will get!!

Shannon Ramirez on 3/26/2009
can you change the directory where the audit file gets placed.. would hate to leave the file in the data folder and get all that fragmintation.. would rather put it on it's own drive...

I didnt know what C2 Auditing is, and I kinda expected this video to show me. Otherwise good. Thanks!

Anatoly Goldstein on 4/9/2009
The author is brilliant lecturer, but I think he forgot to mention at the beginning that the method he is demonstrating requires adminitrative access to SQL Server. Meanwhile the latter is designed as an Enterprize Level Data Managaemnt System and is commonly used as a shared DBMS in numerous corporate environments in which application programmers like myself has no admin privilages and so cannot use the demonstrated method. It looks like the lecturer silently assumes that this method is for DBAs having sa access to the SQL Server. Other than that it's a great lecture and I gave it a highest possible score, the author is extremely fluent in SQL Server technology.

Feroz Durani on 5/21/2009
Apreciate if you could show the difference between "Normal Trace File" and 'C2 Audit Trace File"

ChGuo on 8/26/2009
Great

Tonci on 9/21/2009
Great because it was to the point. Still, how to filter, group, etc trace data would be nice to add. Tonci.

good

Kenneth on 3/11/2010
This is a nice guide on how to enable C2 Login Auditing.

Kenneth on 3/11/2010
Very nice!



Must Be Logged In

References
Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions