• Just a guess.  @@rowcount is returning the rowcount from the current context (in this case, the trigger).

    How about using

    IF (select count(*) from INSERTED) = 0

     

    instead?


    And then again, I might be wrong ...
    David Webb