A linked server enables you to work with other SQL Servers as well as databases other than SQL Server databases, right from within Management Studio.