OptionalSettings - SteveStedman/SqlForensics GitHub Wiki

DisplayChanges

The display changes setting is use by stored procedure [ForensicLogging].[runFullMonitoringPass] to determine if it should be run silently, or if it should display output. The output in this case is a list of changes that were detected on this run of the [ForensicLogging].[runFullMonitoringPass] stored procedure.

Turning Display Changes On

EXECUTE [ForensicLogging].[setSetting] 'DisplayChanges', 'True';

Turning Display Changes Off

EXECUTE [ForensicLogging].[setSetting] 'DisplayChanges', 'True';

Checking The Display Changes Setting

SELECT [ForensicLogging].[getSetting] ('DisplayChanges');