I love the xml type in SQL Server 2005. Here's a very simple way I made use of it: I audit all the object/schema changes to the database with a simple database-level trigger.
First, I create a very simple table (inside a schema I name 'Audit'):
Read More