Aksheela,
Nice description of the problem and the code, thanks. However, the one thing you left out was the delete statement, so I have a few questions.
Do your deletes occur simultaneously in one statement? IE: DELETE FROM tbl1 WHERE colA = @Param, or do you send multiple delete statements from the front end?
If it's multiple delete statements, such as from an ADO recordset doing dynamic SQL, there's nothing you can do to fix this, they are multiple statements, thus firing multiple triggers.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA