Microsoft® SQL Server 2008 R2 Unleashed

Summary

In this chapter, you saw the difference between the more common linked servers and the old type of remote servers. You also 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 ...