>>Sure, although you can also do the same using OUTPUT clause of Update command in your SP that updates the Address table. Triggers should be used as a last resort.
>
>Oh, wasn't aware of OUTPUT clause - will check it out - thanks
Glad to help - it should simplify your life.
If it's not broken, fix it until it is.
My Blog