>>>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.
Isn't OUTPUT introduced in 2005 first?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.