CODEWITHSUNDEEP
sqlsql-serverlinked-server
Brian Tran
Brian Tran

Reputation: 125

Strange SQL Remote Query

enter image description here

I have this remote query (select * from dbo.prod_Enertia_emk_monthly_gas_interface) with the linked server as LIVEDB. How does SQL know to use the bottom selected query to the remote server? I am puzzled as I have never created a remote query before. How does this call work?

Upvotes: 2

Views: 71

Answers (2)

UnhandledExcepSean
UnhandledExcepSean

Reputation: 12804

This is either a view or a synonym. Both can be found in SQL Server Management Studio under the database in question.

enter image description here

Upvotes: 4

Brian Tran
Brian Tran

Reputation: 125

enter image description here

The remote call is using a synonyms.

Upvotes: 1

Related Questions