At 05:52 PM 2/03/2005 +0200, ibrahim bulut wrote:

>Hi Ivan
>i understand your answer.
>but Helen's answer is different from your answer.

Because Ivan answered a different question.

You asked: will triggers still fire?

I answered "Yes". (That is truth.)

Ivan answered No, because he assumed (correctly, it seems :-) ) that your
REAL question was: "Will the use of WITH LOCK syntax CAUSE triggers to
fire?" And that is also the truth. :-)

>Helen said "This form of pessimistic locking does not affect your triggers"

Which is true: whereas, engineering a pessimistic lock by performing a
dummy update WILL cause your update triggers to fire.

>what is the truth

"Truth is nothing but the best of the current hypotheses".

"Truth is beauty; and beauty truth."

./heLen