Strange SQL Remote Query

Question

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?

Is dbo.prod_Enertia_emk_monthly_gas_interface actually a view to a linked server? — UnhandledExcepSean, Feb 26 '19 at 14:43
I looked for object dbo.prod_Enertia_emk_monthly_gas_interface on both local and remote server and cannot find anything. — Brian Tran, Feb 26 '19 at 14:44
It might be a synonym. https://stackoverflow.com/questions/11628061/creating-a-linked-server-and-database-alias — UnhandledExcepSean, Feb 26 '19 at 14:45
The call goes to a view named pdRptEMK3MonthlyGasProdcution on LIVEDB — Brian Tran, Feb 26 '19 at 14:45
SQL call object dbo.prod_Enertia_emk_monthly_gas_interface but does a remote call to "PRD_enertia"."dbo"."pdRptEMK3MonthlyGasProduction2" which is a view on remote server — Brian Tran, Feb 26 '19 at 14:52
The engine needs to know how many columns and which types he's gonna get with your *, so it does a few metadata queries before actually sending the command. This is the result of those queries. — EzLo, Feb 26 '19 at 14:52
So where can I find how object dbo.prod_Enertia_emk_monthly_gas_interface relates to the remote query? — Brian Tran, Feb 26 '19 at 14:54
I see it in SQL Server Management Studio as a folder under each database. Did that query show there were synonyms? — UnhandledExcepSean, Feb 26 '19 at 14:59

score 4 · Accepted Answer · answered Feb 26 '19 at 15:02

4

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

answered Feb 26 '19 at 15:02

UnhandledExcepSean

12,504
2
35
51

score 1 · Answer 2 · answered Feb 26 '19 at 15:01

1

The remote call is using a synonyms.

answered Feb 26 '19 at 15:01

Brian Tran

115
10

Strange SQL Remote Query

2 Answers2