EXEC master.dbo.sp_addlinkedserver @server = N'192.168.7.240', @srvproduct=N'SQL Server' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'192.168.7.240',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='h86827990h' GO SELECT * FROM dbo.TBillAdjDet WHERE BillId = 'ADE171220000001' AND Sku NOT IN (SELECT Sku FROM [192.168.7.240].jhd.dbo.skuList )