<div>
Run this on the second server and it will tell you if you have a linked server setup:<br />
SELECT *<br />
FROM sys.servers
</div>


Run this on the second server and it will tell you if you have a linked server setup:
SELECT *
FROM sys.servers

<div>
I thought it was linked, but just double checked just to be sure. It wasn't set up correctly. I fixed it, and now it works fine. Thanks.
</div>


I thought it was linked, but just double checked just to be sure. It wasn't set up correctly. I fixed it, and now it works fine. Thanks.

<div>
&gt;&gt;I fixed it, and now it works fine.&lt;&lt;<br />
Excellent. &nbsp;Now please close the question.
</div>


>>I fixed it, and now it works fine.<<
Excellent.  Now please close the question.

<div>
See here:<br />
How do I close a question?<br />
<a href="https://www.experts-exchange.com/help.jsp#hs=29&hi=407" rel="ugc">https://www.experts-exchange.com/help.jsp#hs=29&hi=407</a>
</div>


See here:
How do I close a question?
https://www.experts-exchange.com/help.jsp#hs=29&hi=407 [https://www.experts-exchange.com/help.jsp#hs=29&hi=407]

<div>
<div class="content wysiwyg-content">
I have two sql servers (express 2008) on the same domain. On one I can write views that include tables/views from the second server, but on the second server I can not do the same.<br />
<br />
I'm using the standard [servername].[database].[s<wbr />chema].[vi<wbr />ew]. It seems that the second server simply can't find/return the view from server one.<br />
<br />
I've checked settings and things seem to be setup identically.
</div>
</div>


I have two sql servers (express 2008) on the same domain. On one I can write views that include tables/views from the second server, but on the second server I can not do the same.

I'm using the standard [servername].[database].[schema].[view]. It seems that the second server simply can't find/return the view from server one.

I've checked settings and things seem to be setup identically.

writing views of views on another server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.