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:35 am

    #1731082

    DevNate (7/21/2014)

    Sorry yes, synonyms were used.

    etl is the schema.

    table synonyms are used for the following tables.

    S022

    PLPO

    AFPO

    AFKO

    synonyms are pointed to the linked server.

    Still confused. Are you saying that all four of the above tables are actually referenced through a Linked Server? Are they all on the same Linked Server or are there multiple Linked Servers? How about posting the DDL for the synonyms in order to make things clearer.