General information
Forum:
Microsoft SQL Server
Title:
Inserting data across server..
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only