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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s