Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

DML Triggers Expand / Collapse
Author
Message
Posted Wednesday, December 2, 2009 6:15 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, November 7, 2014 1:28 PM
Points: 695, Visits: 265
We have three types of dml triggers,

AFTER Triggers, INSTEAD OF Triggers & CLR Triggers


Anil Kubireddi
Post #827391
Posted Wednesday, February 8, 2012 4:13 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, November 29, 2014 2:17 AM
Points: 483, Visits: 245
I stand corrected, but my determining factor was the 'DML' keyword. Also eliminated the 'CLR' trigger since applies to DML & DDL yet the question was specific to DML.

[url=http://msdn.microsoft.com/en-us/library/ms178134.aspx]

Thanks.
Post #1249398
Posted Tuesday, January 29, 2013 6:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 4:31 AM
Points: 278, Visits: 242
nice question... i too had little cofusion about types of triggers and types of DML Triggers..... tell me what are the types of DDL and Logon triggers?????



+1




manik
*************


Manik
You cannot get to the top by sitting on your bottom.
Post #1413007
Posted Thursday, October 2, 2014 4:53 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 3,751, Visits: 333
Thanks for the question.
Post #1622155
Posted Thursday, October 2, 2014 4:54 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 3,751, Visits: 333
Seems to be some disagreement about this in the comments.
Post #1622156
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse