rlondon (12/12/2007)
In this BOL page, http://msdn2.microsoft.com/en-us/library/ms178134.aspx titled Types of DML Triggers, it states After, Instead Of, and CLR Triggers are types of DML triggers. For triggers are used prior to SQL Server 2005. The only option in the answer that includes all of these is answer number 4.
HI,
Actually in the page CLR also listed as DML triggers but if you see CLR triggers can be used as DML as welll as DDL triggers, and also
"CLR triggers are dependent to .NET " that is why there is only the pure DML triggers that are AFTER and INSTEAD, CLR comes under both CML and DDL,
this is what i think.... What you think.,..
Thanks,
Prashant