Structure Change Log

The Structure Change Log report gives you a clear, chronological view of every structural change occurring across the databases on your SQL Server instance. This includes object creation, modification, and removal, captured with full detail so you always know what changed, when it changed, and who made the change.

This report is ideal for environments where schema stability, audit tracking, or change oversight is important.

What The Structure Change Log Represents

Each row in the Structure Change Log represents a single DDL event captured on the instance. The report includes the timing of the change, the type of operation performed, the affected database and object, the full T-SQL statement, and information identifying the login, user, host, and application responsible.

This combination of structural, contextual, and user-origin data makes it straightforward to trace unexpected modifications, validate planned deployments, and identify the source of accidental or unauthorized changes.

How Structure Tracking Works

Structure tracking is not enabled by default.
To begin capturing DDL activity, select Setup Structure Tracking on the report screen.

You will be prompted to choose the databases where tracking should be active. When a database is selected, Database Health Monitor adds a lightweight database-level DDL trigger named trg_DDLAudit. This trigger records events such as CREATE, ALTER, and DROP statements and logs them centrally so the report can display them.

You can enable tracking on as many or as few databases as you need, and you may disable tracking at any time. Disabling it removes the trigger from the database.

The trigger is designed only to capture event metadata and the original T-SQL. It does not alter objects, block activity, or require additional configuration.

Getting Help from the Stedman Solutions Team

We are ready to help. The team at Stedman Solutions is here to help with your SQL Server needs. Get help today by contacting Stedman Solutions through the free 30-minute consultation form.