How to Find SQL Server Configuration Changes History

This report provides a history of all sp_configure and trace flag changes which are recorded by the default trace. By default, the report is disabled and you need activate it before you can see the relevant data.

To enable the report, you need to execute the following command,

sp_configure 'default trace enabled', 1
GO
RECONFIGURE WITH override
GO

Once done, follow below steps to launch the report,

Right click on database server > Reports > Standard Reports > Configuration Changes History.

The changes history shown as below,

You May Also Like

Leave a Reply?