>>Very interesting! In other words, we can not have only 1 INSTEAD OF trigger defined on a table, we need to have all 3, as BOL suggests, correct?
>
>Yes, that is my experience, I wrote once an INSTEAD OF INSERT trigger only to found out the next day that my agent job failed every time an update or delete was performed for it was using MERGE and I did not have the other two types of triggers, and then is when I found that piece of cra... documentation.
Hugo,
On somewhat related and somewhat unrelated subject. Have you ever had INSTEAD OF UPDATE trigger that updates multiple tables? Any problems with that?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
