Blog Post

Azure SQL Blog
5 MIN READ

Logging Schema-changes in a Database using DDL Trigger

AndreasWolter's avatar
AndreasWolter
Icon for Microsoft rankMicrosoft
Dec 02, 2020
Logging Schema-changes in a Database using DDL Trigger   Every so often I have been asked “how it is possible to log and review the audit-logs when Developers change objects but do not have acces...
Updated Jan 20, 2021
Version 13.0
azure sql
azure sql database
Azure SQL Security
sql server
mbourgon_optum's avatar
mbourgon_optum
Copper Contributor
May 01, 2024

nLightJC ever figure out a way around this issue with DDL Triggers? Log Analytics doesn't work well for DDL changes, and Event Notifications don't exist on Azure SQL Database, so I'm back to using DDL Triggers which I abandoned for the same reason you found. AndreasWolter any suggestions?