>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.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
