Information
The default trace provides audit logging of database activity including account creations, privilege elevation and execution of DBCC commands.
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;