Linked server on SQL server 2008 R2

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?
LVL 2
bergertimeAsked:
Who is Participating?
 
Dave FordSoftware Developer / Database AdministratorCommented:
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
 
Deepak ChauhanSQL Server DBACommented:
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
 
bergertimeAuthor Commented:
Ok.....so sometimes Im a little slow.  Refresh is my friend.  Sorry and thanks
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.