SQL 2005 DDL Audit Sample Applications now available to download
The SQL 2005 DDL Audit Samples are a collection of applications for configuring DDL (Data Definition Language) auditing on one or more SQL Server 2005 instances. These applications were first presented at the PASS 2006 Community Summit in my presentation Building a DDL Audit Solution using SQL Server 2005 and as promised are now available to download. Full source code is provided for all applications and reports.
Download Page for Sample Applications
View the Readme file
Highlights
DDL Audit Admin application - used to configure central audit database and deploy auditing to additional instances (screenshot)
DDL Audit Viewer application - used to view audited events across all monitored instances (Summary, Detail)
DDL Audit Reports - a selection of sample reports used in conjunction with DDL Audit Viewer
Full source code for all applications and reports