Solved

Linked server on SQL server 2008 R2

Posted on 2012-04-02
3
763 Views
Last Modified: 2012-04-02
I've linked our iSeries to our SQL server.  I've created a view with this:

Create View View_name as
 
SELECT *
 FROM [10.1.1.253].[S10778CE].[AIR400].[AGENT]

Where would I find this view?
0
Comment
Question by:bergertime
3 Comments
 
LVL 18

Accepted Solution

by:
daveslash earned 250 total points
ID: 37797285
As far as I can see, that view would live in your SQL Server box. It just references a linked table that points to your iSeries.

Check it out, and let us know what your find.

HTH,
DaveSlash
0
 
LVL 15

Assisted Solution

by:deepakChauhan
deepakChauhan earned 250 total points
ID: 37797578
This view will be created in your sql server where you created it and you can find it in the view folder of the database i which u run this command.
0
 
LVL 2

Author Closing Comment

by:bergertime
ID: 37797710
Ok.....so sometimes Im a little slow.  Refresh is my friend.  Sorry and thanks
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

932 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