Question

Is there a difference between T-SQL linked server and a synonym?

Answer 1

• You use a linked server to connect to a database on a different server.
• You use a synonym to specify the object (e.g. table) you want to access in SQL, it is like an alias.