http://www.sqlservercentral.com/Content tagged SQL Server 2005, SS2K5 Triggers posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)DDL Triggers are key improvement in SQL Server auditing, allowing tracking of events such as the creation of a new table, database or user.http://www.sqlservercentral.com/redirect/articles/3235/2007/09/24http://www.sqlservercentral.com/redirect/articles/3235/This article shows how to use DDL triggers to capture schema changes. This solutions works a little differently than most DDL triggers examples. This script captures the old object that was replaced. http://www.sqlservercentral.com/redirect/articles/3190/2007/08/28http://www.sqlservercentral.com/redirect/articles/3190/Auditing is becoming more important all the time for DBAs as regulations and requirements increase. Building auditing into your systems can be done a number of ways, but with SQL Server 2005, you have a new option. New author David Ziffer brings us a generic auditing CLR trigger. http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/creatingagenericaudittriggerwithsql2005clr/2502/2006/08/02http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/creatingagenericaudittriggerwithsql2005clr/2502/