title: update statement inside Trigger not updating all the rows in SQL server 2008
body: <p>I have two table.table 1 have the update trigge it will update the detail in table. but table have many rows with same key in table1.(key in table1 is primarykey but in table 2 it is foriegn key). Update trigger updating only one row in The table2 not updating the all row having same key.</p>
  
  <pre><code>Update  table2 set colu1 = "value" where  colu2 = primarykey
  </code></pre>