I have this code to get a records from a different server. The name of the server is sqlclust. When I run the following code and modify the code "sqlclust.Canondn.dbo.vre-----------" i get an error saying i have to run sp_addlinked server. I am not familiar with that. How do I modify the code below to get the records frm the db called canondn that resides on server sqlclust.
SELECT d.Model, d.Ref_ID, Customer_Name_ID as Customer_Name_ID, @SID as SourceID
FROM Canondn.dbo.vreferral_for_CustomerMaster d
Inner Join tblCustomer_Name c On
@Sid = c.SourceID
and d.Ref_ID = c.R_CustID
WHERE d.Model is not null AND d.Model <> ' ' and CMRecord is Null