>>>>>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?
No ! Pete uses 2005
Regards,
Peter J. Kane
Pete