oops didn't mean to post my reply twice. 

Remi, thanks for all help and posts.

Probably a scheduled DTS job.

Probably a sceduled dts job.

I have inserted my recent comments in green below. 

Thanks so much for your help! (and patience )

SELECT *

into #v_saleproperty

FROM OPENQUERY(Server1, 'Select city, MLS_nbr from...

okay sorry.  left out that step.  after i alter the table to add the city column with the data from server1, i would then alter the view by selecting from...

On server2 I have a view v_homes that I need to add a city column which is populated from server1.v_HomeSales.city.  hope that makes sense.

thanks for the reply.  the view I am altering is on server 2 though.