I have database named Orders on Server named PrimeServer.
I have a Linked Server object built (and working) on PrimeServer to a secondary server named OtherServer. The link shows the view I want named VW_MyOrders.
My goal is to build a view on my Orders database that links these 2 views together (the linked server view and the database view to create a new view)
I am trying to figure out can I do this visually or do I need to write it manually?
This is the view I have created on my Orders database:Other
SELECT CONumber, OrderDate, Confirmed
I want to link this view to a view on my Linked Server view named VW_MyOrders. My goal is to link the CONumber value on the 2 views but I usually work visually on SQL Views and cannot figure out how to get the 2 views linked together to give me live data.
This is the view from my Linked server:
How do I link the 2 servers and create a view in the PrimeServer in database named Orders?