can implement the database trigger to cover objects by
create trigger xxx on database for --ddl_function_events--, ddl_index_events
--, ddl_procedure_events
--, ddl_table_events
--, ddl_synonym_events
--, ddl_view_events
--, ddl_type_events
--, ddl_sequence_events
ddl_database_level_events
These objects are not covered and changes made to these objects are not audited
I believe Dan Downey put something similar together.
Attachments Open full size