0

the issue: We have a Db named for example 'DBUni' and 4 SQL servers In various cities

  • Server1 is connected to Server 2
  • Server2 is connected to Server 1,3
  • Server3 is connected to Server 2,4
  • Server4 is connected to server 3

Problem: We have to have a SQL Connection from Server 4 to Server 1

Right now 'DBUni' is on Server1 and it is Linked To Server2 through SQL Server Link Servers

Does anyone have a solution?

Hamid Shoja
  • 3,838
  • 4
  • 30
  • 45

1 Answers1

1

You could create a view on the linked server referring to the other linked servers, this could become an extensive list of views though.

The view would not be restricted to only the same server, since it can refer to a different linked server. This way you could make a hierarchy of views. I have no idea how this would affect performance though.

t-clausen.dk
  • 43,517
  • 12
  • 59
  • 92