In addition to developers' use of version control products in studios apps, we have a database trigger which logs all DDL changes. So every DDL change is logged into a table. In addition to the EventData() data we also log the Change ID initiating the change and any comments. So in production I know exactly when and why objects were changed.