Sometimes you need to track changes to IIS configuration. Maybe a virtual directory keeps disappearing? Follow a few simple steps, and you’ll be able to point the finger with supreme confidence when that happens.
By following the steps outlined at the official Microsoft IIS site, you can record entries to the event log any time something is changed in the IIS configuration.
Sometimes, when developing, you don’t really want to worry about running out of space on your development SQL server. In that same development environment, it may not be important to preserve a transactional record of your test data. In that case, you can truncate transaction logs all you want.
This script has been tested only on Microsoft SQL Server 2005.
View the code snippet at GitHub.