Information
The default trace provides audit logging of database activity including account creations, privilege elevation and execution of DBCC commands.
Rationale:
Default trace provides valuable audit information regarding security-related activities on the server.
Solution
Run the following T-SQL command:
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;
Default Value:
1 (on)