Default trace log files disabled
Applies to: SQL Server
This rule checks the value of the sp_configure
stored procedure default trace enabled option to determine whether default trace is set ON (1) or OFF (0). When this option is enabled, default tracing provides information about configuration and DDL changes to the SQL Server Database Engine. In some cases, this information can be helpful for customers and Microsoft Customer Service and Support when they're troubleshooting issues with the Database Engine.
Best practices recommendations
Use the sp_configure
stored procedure to enable tracing by setting the value of default trace enabled to 1.
For more information
Server configuration options (SQL Server)