March 7, 2017 at 11:10 am
No, but the question did not specify that it was only about DML Triggers.
March 7, 2017 at 12:35 pm
It says after triggers on a table. These would be DML triggers.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
March 15, 2017 at 6:21 am
However, if the same trigger is defined for several actions you can't add the values returned by OBJECTPROPERTY - see also an older post by Luis Casares...
March 24, 2017 at 11:20 am
dmoldovan - Wednesday, March 15, 2017 6:21 AMHowever, if the same trigger is defined for several actions you can't add the values returned by OBJECTPROPERTY - see also an older post by Luis Casares...
Yes, as Luis pointed out the "correct" answer is clearly incorrect. When I define a single trigger that dealswith 3 operations that's a single trigger, not 3 triggers. So all "you can't do it" answers should have points.
And of course there was the added complication that the original form of the question didn't specifically exclude instead of triggers, but the 3 trigger count ops do exclude them (a fact that, as far as I can see, is nowhere docuented, we just have to find out the hard way - well done yet again, Microsoft).
Tom
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply