CODEWITHSUNDEEP
sql-serverlinked-serversynonym
Travis Ingram
Travis Ingram

Reputation: 397

SQL Server 2012 - Synonyms

SQL Server 2005/8 allows you to associate a synonym with a remote table (i.e. a table on a different instance - the reference is via a 4-part name, which includes the link server name). Does anyone know whether SQL Server 2012 allows a synonym to be directly associated to the Link Server name (rather than a table which exists on the target)

Upvotes: 0

Views: 1795

Answers (2)

Las Ten
Las Ten

Reputation: 1175

Why don't you just duplicate the linked server with your desired new name? That's not a synonym, but the same server will be available with two names, so in practice they are pretty much the same.

Upvotes: 1

Stuart Ainsworth
Stuart Ainsworth

Reputation: 12940

Looking at the Books Online for SQL Server Denali, there appears to be no change in syntax or usage for SYNONYM's. Probably a safe bet to assume there will be no difference.

Upvotes: 1

Related Questions