In Parts 1 and 2, we introduced the Linked Server. Starting
with what a Linked Server is, the benefits to using them, as well as when to
avoid them. The Distributed Transaction Coordinator, DTC, was touched on. In
addition, our first examples were to create links to an Excel spreadsheet,
during which, four-part naming was reviewed. The functions sp_addlinkedserver,
openrowset, and sp_dropserver were used. Moreover,...