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
DevNate
Old Hand
Points: 326
More actions
July 21, 2014 at 10:53 am
#1731092
Once again I apologize.
All synonyms are pointed to the same server and created as follows. Of course replacing the appropriate table name where required.
CREATE SYNONYM [etl].[AFKO] FOR [SAPETL].[ERP].[erp].[AFKO]