• You could put a trigger on the table but I don't think you can directly pass parameters to it, so there may not be a way to get the new values to your second table.

    My suggestion would be to change your stored procedure to update both tables like someone else mentioned. This is a more direct approach and gives you total control of the transaction in one place.

    Mark