As a DBA, do you ever wonder what is going inside your production database? Who is changing database schema during production time without informing you. Now, you need not to worry, you can setup DDL triggers to easily records all changes in table; like what was changed, when and by whom etc. Given is two [...]
Posts Tagged ‘DDL_DATABASE_LEVEL_EVENTS’
Audit databases – Using DDL triggers
Posted: 5th June 2010 by Deepak in Scripts, SQL DBA, UncategorizedTags: change log, DDL Triggers, DDL_DATABASE_LEVEL_EVENTS, event, event_instance, msdb, sql audit
3
