<div>
<div class="content wysiwyg-content">
I have this code to get a records from a different server. &nbsp;The name of the server is sqlclust. &nbsp;When I run the following code and modify the code &quot;sqlclust.Canondn.dbo.vre-<wbr />----------<wbr />&quot; i get an error saying i have to run sp_addlinked server. &nbsp;I am not familiar with that. &nbsp;How do I modify the code below to &nbsp;get the records frm the db called canondn that resides on server sqlclust.<br />
<br />
SELECT &nbsp; &nbsp; d.Model, d.Ref_ID, Customer_Name_ID as Customer_Name_ID, @SID as SourceID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Canondn.dbo.vreferral_for_<wbr />CustomerMa<wbr />ster &nbsp;d<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Inner Join tblCustomer_Name c On <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@Sid = c.SourceID<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;and d.Ref_ID = c.R_CustID<br />
WHERE d.Model is not null AND d.Model &lt;&gt;&nbsp;' ' and CMRecord is Null <br />
<br />
thank you
</div>
</div>


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 

thank you

getting data froma different server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.