Chapter 11. Linked Servers and Distributed Transactions

Networking environments are becoming more and more complex. Organizations that managed with a single Microsoft SQL Server now need additional servers, or they need to integrate their existing server with other heterogeneous data sources. SQL Server 2005 provides several features for integrating SQL Server databases with other SQL Server databases and with other data sources, including distributed data, linked servers, and replication. This chapter focuses on linked servers and distributed data. Distributed data includes support for distributed queries, distributed transactions, and remote stored procedure ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant 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.