Connect a Linked DB to a DB

Posted on 2011-04-26
Last Modified: 2012-05-11
In SQL Server 2008 R2:

I have my DB linked from the AS400 but now I want to create a view?
I want to be able to write queries and reports againts the DB.

When I create a new quety IntelliSence does not pull up the DB
Question by:jaymz69
    1 Comment
    LVL 42

    Accepted Solution

    if you have created  linked server on your sql server 2008  to AS/400

    you can create views the sam way as regular onws
    Create view vw_AS400


    select * from vw_AS400

    sql server 2008 IntelliSence is for your sql server not linked servers

    this feature is limited to SQL Server 2008 instances--

    as alternative, you can click on you linked server and it will open objects on AS/400 those that your DSN used account has access to
    from hee you can script "select "


    however, if sql server 2008 IntelliSence does not work for you at all:
    you may need to check ssms version (no intSense on express )  and may shure it is enabled

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    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 …
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now