Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, December 17, 2015 3:03 PM
Points: 502, Visits: 259
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 13, 2015 8:18 AM
Points: 342, Visits: 278
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
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, January 7, 2016 4:07 PM
Points: 6,265, Visits: 630
Thanks for the question.
Post #1622155
Posted Thursday, October 2, 2014 4:54 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, January 7, 2016 4:07 PM
Points: 6,265, Visits: 630
Seems to be some disagreement about this in the comments.
Post #1622156
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse