Home Forums Article Discussions Article Discussions by Author Discuss content posted by Prashant Pandey DML Triggers RE: DML Triggers

  • December 13, 2007 at 1:18 pm

    #760006

    Andrew Fitzgerald (12/13/2007)

    MS On-line help for SQL lists three Types of DML triggers: After, Instead of and CLR.

    Tempted as I now am to submit a documentation bug report, I can't deny that this is indeed exactly what Books Online says. I disagree with it (but that's not new, I disagree with lots of stuff in BOL), but it is official so I guess that those who answered "three (after, instead, clr)" should be awarded a point.

    And maybe the question needs to be retracted...

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/