Summary
In this chapter, you saw the difference between the new linked servers and remote servers. You also learned how distributed queries and transactions worked with linked servers. In addition, you learned how to set up, configure, and gather information on linked servers 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 Enterprise Manager. These foundation skills will be the cornerstone of helping your organization expand its reach to data no matter where it resides.
Although linked servers provide a method to access ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.
