Chapter 12. Linked Servers and Distributed Transactions

Networking environments are becoming more and more complex. Organizations that managed with a single server now need additional servers, or they need to integrate their existing server with other heterogeneous data sources. Microsoft SQL Server 2008 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 execution. ...

Get Microsoft® SQL Server® 2008 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.