>>>>>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?
:-)
At least this is showed as version of SQL Server above :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.