Conclusion
This chapter focused on how to read data from remote data sources and how to write data to remote data sources. Remote sources can be either another SQL Server instance or a different type of data source. You can do all of this using T-SQL. SQL Server Management Studio provides a user interface for managing remote sources.
Chapter 8 Quick Reference
| To | Do this |
|---|---|
| Execute infrequent queries against a remote resource by sending a pass-through query | Use the OPENROWSET function. |
| Execute infrequent queries against a remote resource by referencing an object using its four-part name | Use the OPENDATASOURCE function. |
| Create a new linked server using SQL Server Management Studio | In SQL Server Management Studio’s Object Explorer window, expand a SQL Server ... |
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.
