O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

Summary

In this chapter, you learned how distributed queries and transactions work with linked servers. Specifically, you learned how to set up, configure, and gather information on linked servers by using the system stored procedures, including sp_addlinkedserver, sp_dropserver, sp_serveroption, sp_linkedserver, sp_table_ex, sp_column_ex, sp_addlinkedsrvlogin, sp_droplinkedsrvlogin, and sp_helplinkedsrvlogin. Finally, you learned how to configure linked servers through SQL Server Management Studio and tighten up the security access around the use and execution of linked servers. These foundational skills are the cornerstone of helping your organization expand its reach to data, no matter where it resides.

Keep in mind that although linked servers ...

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