How to avoid 4-part naming to linked server to an Oracle database in SQL Server while using DBPro

   Scenario 1.  You have set up a linked server to an Oracle database in SQL Server 2.  You have created a synonym for an Object from the Linked Server               CREATE SYNONYM [dbo].[SynonymProducts]     FOR [Oracle_DATABASE]..[PRODRHDW].[Products] 3.  Attempt to access the synonym: Create View [dbo].[ViewProducts] AS SELECT * FROM SynonymProducts causes – TSD03006: unresolved reference…