Your solution:

I used Update trigger to fire the stored proc per record. I was thinking triggers in SQL Server work the same way it does in Oracle but unfortunately i...