We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Instead of inserting every single row on every execution, like in my scrpt, is it possible to only insert new rows on local server ?
truncate table [localserver].[DBName].dbo.linktest go insert into [localserver].[DBName].dbo.linktest ( ID,Name ) select ID,Name from [remoteserver].DBName.dbo.linktest with (nolock)