hi,

i need to copy data from a developement table to a prodcution table on different servers..


this works if your on the same server...

insert into destination_table
select *
from database_name.dbo.source_table

but if your crossing servers could you modify this insert commands from clause to include server name ie

from server_name.database_name.dbo.source_table

or something like that or is should i be using dts.

tia