I needed some data from one of my tables in one server to be inserted into another, here is the simplez SQL to do it.
insert into Server1.Database.dbo.Table(Col1,Col2,Col3)
select Col1,Col2,Col3
from Server2.Database.dbo.Table
Edit:
thanks to @duncansmart just a bit more info, I'm running on 2008 R2, on previous systems you may need to run
Execute sp_addlinkedserver Server1
To link in the other Server
0 comments:
Post a Comment