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 02, 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, May 17, 2013 5:00 AM
Points: 662, Visits: 239
We have three types of dml triggers,

AFTER Triggers, INSTEAD OF Triggers & CLR Triggers


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

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

Group: General Forum Members
Last Login: Monday, May 20, 2013 9:43 AM
Points: 469, Visits: 193
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:18 AM
Points: 152, Visits: 155
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
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse