O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Designing a Strategy to Manage Data Across Linked Servers

Users often need to query data stored on multiple and sometimes disparate systems. You must provide a method for users to have their data available and to query the data as though stored on the system the users are initially logging into. Your solution should allow users to issue queries that reach beyond the data in their server to include the remote data they have permission to access. This solution needs to provide access to the remote server as well as the ability to address diverse data sources in a similar manner. Your solution is linked servers (see Figure 8.1).

FIGURE 8.1 Linked servers

Linked servers begin their processing when an application requires a result set that is at ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required