Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Brian Knight Creating a Synonym for a Table - SQL School Video RE: Creating a Synonym for a Table - SQL School Video

  • January 21, 2009 at 6:27 am

    #930269

    Not sure what you are referencing here, but you can easily create a synonym that accesses an object through a linked server.

    Create the linked server, then in the local database create the synonym as:

    CREATE SYNONYM MySchema.Object FOR linkedserver.remotedb.schema.object;

    I basically want a synonym on a whole database, not an object at a time. Currently I have to use a combination of a Client Network Alias and a Linked Server to accomplish this;

    For example - Server 1 needs to query Northwind on Server 2. On server 1:

    Create a Client Network Alias named NorthwindAlias and point it to Server 2.

    Create a Linked Server named NorthwindAlias and map logins.

    Write a query referencing NorthwindAlias.dbo.xxxxx, etc.