>>>>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?
Yes. Does Pete still use SQL Server 2000?
If it's not broken, fix it until it is.
My Blog