|Bill Wunder's DDL Archive Utility|
Using the Utility's Data
There is a significant amount of useful information available in the Archive Utility and in the output produced by the utility.
Change detail history stored in SourceSafe
To view the details of a particular change use the SourceSafe GUI to view the history of an interesting file and then display the differences between selected check in versions of that file. Please see the SouceSafe documentation for complete information regarding the use of the User Interface.
Any Archive Utility configuration changes are also stored as files in SourceSafe. These files are always located in the project folder for the SQL Server.
Writing queries to report on logged changes
Queries against the log data stored on the SQL Server can be easily grouped and/or sorted by object type (stored procedures, tables, jobs, etc.) and database as well as by datetime using standard T-SQL queries.
A few example stored procedures are installed with the Archive Utility: