How about automatically tracking and logging all database changes,
including changes to tables, views, routines, queues and so on? With SQL
Server 2005 it isn't that hard, and we'll show how it is done. If you
haven't got SQL Server 2005, then get SQL Server Express for free. It
works on that! While we're about it, we'll show you how to track all
additions, changes and deletions of Logins and Database Users, using
a similar technique.