C2 Auditing–Enable

C2 auditing is easily enabled, by writing the following SQL Statement and then restart the instance:

sp_configure ‘show advanced options’, 1

sp_configure ‘c2 audit mode’, 0

When that is done, then you can easily find information that are captured by the C2 auditing. Go to your datafolder of the SQL Server, and find the audittracefiles (ending on .trc).You can then open them in SQL Server Profiler or you can use the following code.

FROM ::fn_trace_gettable(
‘D:\SQL2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\audittrace20121110183153.trc’, default

But I would recommend opening it up in SQL Server Profiler.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *