SQL -Need Help

[squrel]

Hi...
I have 2 servers, one live and the other one local server... i have a table called txpaychq and there is column name paymode which has been deleted from my local server... i made the column and the values is Null.. how can i get the values of this column(paymode) from the live server to local sever?
Thank u

[hatrick]

have you tried the Import/ export wizard in the enterprise manager.??

[amitpatel66]

Hi...
I have 2 servers, one live and the other one local server... i have a table called txpaychq and there is column name paymode which has been deleted from my local server... i made the column and the values is Null.. how can i get the values of this column(paymode) from the live server to local sever?
Thank u

Try using database link for the purpose

[squrel]

Got it... Thanks a lot