Pressing the Red Button

SQL Server Synonyms and Linked Servers

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...