Chapter 8. Working with Data from Remote Data Sources
After completing this chapter, you will be able to:
Open ad hoc connections to a variety of data sources using T-SQL
Configure a linked server using T-SQL
Configure a linked server using Microsoft SQL Server Management Studio
Update data in remote data sources
In Chapter 4, “Transferring Your Database to Other Systems,” you learned how to transfer local data to remote database servers, how to use the different replication options that SQL Server 2005 offers, and how to use SQL Server Integration Services to communicate with a variety of data sources.
In real-world applications, when you need to work with data from a remote data source, it is not always possible or desirable to set up a replication ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
