The '@@ROWCOUNT > 0' is not reliable way to check for # of inserted record. What if somebody adds one more INSERT trigger that would fire before yours? The following is better
IFNOTEXISTS ( SELECT1FROM Inserted )
>I added a check for @@ROWCOUNT > 0 in the trigger which cured the problem. So would, for instance. a DELETE trigger fire even if there were no actual deletions ?