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;