Chapter 12. Linked Servers and Distributed Transactions

Networking environments are becoming more and more complex. Organizations that have managed with a single server now need additional ones, or they need to integrate their existing server with other, heterogeneous data sources. Microsoft SQL Server 2008 provides several features for integrating one SQL Server database with other SQL Server databases or with other data sources. These features include 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® 2008 Administrator's Pocket Consultant, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.