[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Connect a Linked DB to a DB

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
0
jaymz69
Asked:
jaymz69
1 Solution
 
Eugene ZCommented:
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
as
SELECT
col1FROM
    AS400.s12.NS34.WS56

----------
go

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

http://www.techrepublic.com/blog/datacenter/using-intellisense-in-sql-server-2008/446
http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/185812ce-442d-4e73-8daf-d8f9b3372361/
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now