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
reconfigure

sp_configure ‘c2 audit mode’, 0
reconfigure

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.

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

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 *