| SQL 2005 DDL Audit Sample Applications |
| Author |
Jasper Smith |
Hits |
5428 |
| Create Date |
10-12-2006 |
Last Updated |
10-12-2006 |
| Versions |
SQL2005 |
|
|
Overview
The SQL 2005 DDL Audit Samples are a collection of sample 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. They build on top of the Service Broker and Server Event Notification infrastructure available in SQL Server 2005 to provide a means of collecting all server and database DDL events in a central database for viewing and reporting. Full source code is provided for all sample applications to allow you to better understand the technologies and easily build on or modify these samples for use in your environment.
Download DDL Audit Sample Applications (1.0.0.0)
View the Readme file
|
Key Components
- DDL Audit Admin application - used to configure central audit database and deploy auditing to additional instances
- DDL Audit Viewer application - used to view audited events across all monitored instances
- DDL Audit Reports - a selection of sample reports used in conjunction with DDL Audit Viewer
- Full source code for all applications and reports
Tested Environments
- Windows XP Professional SP1/SP2
- Windows Server 2003 RTM/SP1/R2
- SQL Server 2005 RTM/SP1
- SQL Server 2005 Reporting Services RTM/SP1
Installation Notes
- To install the SQL 2005 DDL Audit Sample simply unzip the DDLAuditSample.zip download file to a folder on your local PC and run the enclosed setup application (DDL Audit Install.msi).
- This install does NOT make any configuration changes to any SQL instances, it merely copies all the applications and source code to the following folder (by default) C:\Program Files\sqldbatips\DDL Audit Sample
|
Requirements
In order to run the DDL Audit Sample applications you need to have the .NET Framework 2.0 and SQL Server Management Tools installed. To modify the source code you need to have a version of Visual Studio 2005 installed (other than SQL Server Business Intelligence Development Studio). Express versions of Visual Studio 2005 can be downloaded for free from here (Source code is C#).
Author |
Date |
Version |
Description |
Jasper Smith
|
10-12-2006
|
1.0.0.0
|
Initial public release
|
|
articles
