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)
References:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/default-trace-enabled-server-configuration-option