SQLKnowledge.com

Day by day Experience of a Microsoft SQL Server production DBA & Consultant..

Audit databases – using ddl triggers

 
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 [...]