多个服务器间不同数据库访问

--注册远程数据库服务器：
--EXEC sp_addlinkedserver 'NWTS', N'SQL Server'
--注册远程数据库服务器的登录方法：
--EXEC sp_addlinkedsrvlogin 'NWTS', 'false', NULL, 'sa', 'ls!'

 

select f.WarrantyClaimFileID,c.ClaimRefNo,w.WarrantyFullNumber,f.FileName,f.Comment,c.ClaimDate from
NWTS.NationalWarrantyStorageJenny.dbo.WarrantyClaimFiles f
join NWJennyDS.dbo.Claims c
on c.ClaimID = f.WarrantyClaimID 
join NWJennyDS.dbo.Warranty w on w.WarrantyID = c.WarrantyID 
where (c.AssignedRepairerID =78203 or c.PaidRepairerID =78203)
and f.FileType =1 and c.WarrantyClaimStatusID !=10