Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

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?
0
bergertime
Asked:
bergertime
2 Solutions
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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