Home Forums SQL Server 2008 SQL Server 2008 - General Synonym with servername\instancename RE: Synonym with servername\instancename

  • June 16, 2010 at 9:25 am

    #1181100

    I think you confused server and database. Does this work?

    CREATE SYNONYM [dbo].[Product] FOR [06WEBSQL\WEBSQL].[06dw].[dbo].[Product]

    -- Gianluca Sartori