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

Technology CommunityCategory: T-SQLIs there a difference between T-SQL linked server and a synonym?
VietMX Staff asked 3 years ago
  • 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.

You can let point a synonym to an object of a linked server, but you still need that linked server.