Microsoft® SQL Server 2008 R2 Unleashed

What’s New in Creating and Managing Triggers

The features and methods available for creating and managing triggers are essentially the same in SQL Server 2008 as they were in SQL Server 2005. The upside to this is that you can take the knowledge and skills that you have with SQL Server 2005 and apply them directly to SQL Server 2008.

One area that has had some minor changes in SQL Server 2008 relates to events captured by DDL triggers. In SQL Server 2008 more system stored procedures that perform DDL-like operations fire DDL triggers and event notification. In SQL Server 2005 certain system stored procedures would fire DDL triggers, but there are many more included in SQL Server 2008. For example, the execution of the sp_rename stored procedure ...