CODEWITHSUNDEEP
sqlsql-serverlinked-server
Przemyslaw Remin
Przemyslaw Remin

Reputation: 6940

How to force SQL to use linked server not the original sever

I have added a linked server 'LinkedServer2' (which is linked to 'OriginalServer2') to my LocalServer. Sometimes I have an issue that it either sees only my LocalServer or the OriginalServer2. And it is a fiasco because I cannot join to tables.

How to run code forcing it to start from my LocalServer and then join table from LinkedServer2 (not OriginalServer2).

Sometimes restarting SQL Management Studio helps adding to the mystery. I use SQL 2008 R2.

Upvotes: 0

Views: 61

Answers (1)

Luke Franklin
Luke Franklin

Reputation: 355

Not 100% on question but you can query linked servers using [server].[database].[schema].[table]

Upvotes: 1

Related Questions