ChrisM@home (7/21/2014)
Lynn Pettis (7/21/2014)
DevNate (7/21/2014)
Lined server is connected via Symbols.So you are saying the Linked Server is hidden by using a synonym? Well, not obvious from what you posted. What is the synonym used so we can tell which table in the query is actually a linked server.
Can you confirm with your DBA that this is actually the case? I can't see how this object naming convention of schema.linkedserver can work.
The beauty there is that the linked server is obfuscated through the use of synonyms. So in this case, they are referencing schema.synonym.
Obfuscating it like what has been done is only going to compound problems when trying to troubleshoot it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events