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

  • June 16, 2010 at 9:41 am

    #1181115

    Gianluca Sartori (6/16/2010)

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

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

    This worked! Thank you!

    I was about to throw my desk through the wall. . .