Up until now, you have been accessing data that resides on only one server, and possibly in only one database.
Did you know that you can access data from tables that are not on the same server?
This is possible. In fact, you can also execute stored procedures located in another database on another server. This module shows you how to do all that.
After completing this module, you will be able to:
Set up servers for remote data
Execute remote stored procedures
Construct and execute queries from remote data sources
In the next lesson, you will learn how remote data access is achieved in SQL Server 2012.