Microsoft® SQL Server 2005 Unleashed

Chapter 42. 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 Studio

As your databases grow in size, complexity, or geographic distribution, you might find it necessary to spread your data across multiple servers. You might also need to bring together disparate data that is not all on one server in order to fulfill a business need. SQL Server has long had the ability to perform server-to-server communication. This can ...