Ok, I am impressed with everything in SQL Server 2005, especially extended triggers to capture DDL actions. I was playing around with these today and I can see how this will be a nice feature, especially for audit trails. I've included a simple script below.
-- create sample dbcreate database trigtestdbgouse trigtestdbgocreate table tblextrig (eventid int identity, eventdata xml)go-- create event driven triggercreate trigger trig_ddl on database for create_table, drop_table, alter_tableas insert tblextrig values (eventdata())go
-- do some ddlcreate table ben (id int)drop table bencreate table ben (id int)go-- check if DML events have been logged by triggerselect eventid, eventdata from tblextriggo-- clean upuse mastergo
drop database trigtestdb