The tool is currently alerting us to when triggers are enabled/disabled. The trigger itself isn't changing, just the status. It would be nice if the tool wouldn't see the this as a schema change.
Adminfiona.gazeley (Admin, Redgate) commented
Hi John. Thanks very much for your feedback.
We talked about this as a team but our feeling was it was better for the tool to treat a trigger enable/disable as a schema change. For example a trigger being disabled by accident on a production server would be exactly the kind of thing DLM Dashboard ought to alert you to.
However I do take your point that it would be good if the filters mechanism could cope with this granularity of trigger related changes (ie enable/disable vs trigger content change).
I’ll leave this suggestion open so that others can comment on this if they have similar concerns.
John Morehouse commented
Just as a follow up, I looked into using filters to get around this but I don't see way to ignore this type of change, just ignore triggers as a whole. If the trigger itself changes, I want to know about it but not if the trigger is enabled/disabled.