Tag Archive | "SQL Server"

SQL Server Synonyms and Linked Servers

Wednesday, October 15, 2008

1 Comment

Here is how you can create a synonym to a linked server in SQL Server 2005/2008: CREATE SYNONYM LinkedTableA FOR ServerName.DBName.dbo.TableA SELECT * FROM LinkedTableA Some Background: What are Synonyms? They are a minor feature added in SQL Server 2005. They are used to create an alias (or easy to remember name) for a server […]

Continue reading...