Home Forums SQL Server 2008 T-SQL (SS2K8) CTE with Linked Server: Mulitpart Identifier could not be bound RE: CTE with Linked Server: Mulitpart Identifier could not be bound

  • July 21, 2014 at 10:40 am

    #1731084

    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.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]