What does your view look like? SQL Server doesn't like inserting values into "complex" views, iirc.

The move from Microsoft SQL Server 2000 to 2005 was a big leap with many new functionalities and features introduced. The concept of DDL Triggers was one such new feature.