Chapter 54. Managing Linked and Remote Servers

IN THIS CHAPTER

• What’s New in Managing Linked and Remote Servers

• Managing Remote Servers

• Linked Servers

• Adding, Dropping, and Configuring Linked Servers

• Mapping Local Logins to Logins on Linked Servers

• Obtaining General Information About Linked Servers

• Executing a Stored Procedure via a Linked Server

• Setting Up Linked Servers Through SQL Server Management

As your databases grow in size, complexity, or geographic distribution, you might need to spread your data across multiple servers and locations. You might also need to bring together disparate data that is not all on one server or is not all in the same type of data container (Access, Excel, text files, and other RDBMSs) to fulfill ...

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

Start your free trial