İki Farklı Server Aktarım

INSERT INTO OPENDATASOURCE('SQLNCLI','Data source=192.168.1.6;initial catalog=NETSIS;persist security info=False;uid=sa;pwd=s1244244@*').AKKASGROUP2016.DBO.TBLESNOZMAS
Select * FROM VIPA2016..TBLESNOZMAS WHERE OZKOD NOT IN
(Select OZKOD FROM OPENDATASOURCE('SQLNCLI','Data source=192.168.1.6;initial catalog=NETSIS;persist security info=False;uid=sa;pwd=s1244244@*').AKKASGROUP2016.dbo.TBLESNOZMAS)

FORMAT SONRASI ÇALIŞTIRILACAK İŞLEM

EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO

Bu makaleyi yararlı buldunuz mu?