SQL Server - Setting the Default Trace Enabled server configuration option to 1
The default trace provides audit logging of the database activity including account creations, privilege elevation and execution of DBCC commands.
Run the following T-SQL command on the IRC and the CM database;
EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE;
EXECUTE sp_configure 'Default trace enabled', 1;
RECONFIGURE;
GO
EXECUTE sp_configure 'show advanced options', 0;
RECONFIGURE;