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 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.