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.
But I would recommend opening it up in SQL Server Profiler.