I have the following set-up:
SQL-Server 1 --linked--> SQL-Server 2 --linked-> SQL-Server 3
The question is can I query SQL Server 3 from SQL Server 1 via SQL Server 2?
I have unfortunately several restrictions:
- cannot use openquery
- cannot use views on Server 2 (there would be many of them and they'd have to be maintained)
- cannot create a link from Server 1 to Server 3 (due to firewalling issues)
- servers are MS SQL Servers