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.

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...

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...

Mogammad Igsaan Ackers on 3/30/2009

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.

Pradeep Kumar Satapathy on 9/28/2009

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!

Srinivas on 6/15/2010

Smooth and simple. Good job. Also if you could explain the server side trace audit and talk about the differences, it would give us a better insight into this whole audit world.