insert into TableXfrom ( Select * from SystemB.DatabaseName.dbo.TableX where ..... )
insert into TableXfrom ( Select * from SystemA.DatabaseName.dbo.TableX where ..... )
EXEC sp_addlinkedserver @server = N'SystemB', @srvproduct=N'SQL Server'
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend