I called update query from table1 trigger, when that query runs, it updates other table2 successfully but update trigger of table2 is fired only 1 time means not for every record that was updated from query of update
I'm using SQL Server 2008 Express edition-
Please guide me where I am wrong
Finally got the answer,
Trigger fire once for single query execution. mass or bulk update/insert/delete will not awake trigger for every row