Transfer Data one server to another

Question

I want use  insert into sql query sqlserver2008   

like this  

insert into server2 table  select * from server1 table

but is not use