inserting from 1 sql server onto another

[rtdvoip]

Hiya fellas,
is it possible, and I am somehow sure it is, to
do an insert from a sql database on 1 physical server onto another seperate physical server?
If so could someone shed some light on how it may be
done.

Thanks in advance for your help.
rtdvoip

 

[JayKusch]

INSERT INTO ServerB.MyDB.dbo.MyTableB

SELECT * FROM MyTableA

Thanks

J. Kusch