writing views of views on another server

Posted on 2011-10-31
Last Modified: 2012-05-12
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.
Question by:michaelmm22
    LVL 18

    Accepted Solution

    Do you have the servers linked in both directions?
    LVL 75

    Expert Comment

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

    Author Comment

    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.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>I fixed it, and now it works fine.<<
    Excellent.  Now please close the question.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    See here:
    How do I close a question?

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Suggested Solutions

    I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now