Unanswered: Linked Server reference to another Linked Server
We have been accessing a table on a SQL 2000 server via a linked server connection managed by a different part of the organziation.
Our source decided to change the location of the data and replaced our table with a view that reference the table through another linked server connection. (chaining them) Their thought was that the change would be transparent to us.
Any query (i.e. select count) now just hangs and never returns. I have tried multiple collation settings since at least one of their servers uses a non-default collation. Politically, their security people are against giving us a login to configure our link directly to their new table location.
I am trying to get more information on how their new linked server is configured, and if it is accessing the table in Oracle now which might be the case. Does anyone know of any clear limitations to linked server chaining or a setting I may be missing.