writing views of views on another server

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.
michaelmm22Asked:
Who is Participating?
 
lluddenConnect With a Mentor Commented:
Do you have the servers linked in both directions?
0
 
Anthony PerkinsCommented:
Run this on the second server and it will tell you if you have a linked server setup:
SELECT *
FROM sys.servers
0
 
michaelmm22Author Commented:
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.
0
 
Anthony PerkinsCommented:
>>I fixed it, and now it works fine.<<
Excellent.  Now please close the question.
0
 
Anthony PerkinsCommented:
See here:
How do I close a question?
http://www.experts-exchange.com/help.jsp#hs=29&hi=407
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.