Microsoft® SQL Server® 2012 Bible

367 CHAPTER 15 Executing Distributed Queries IN THIS CHAPTER Understanding a Distributed Query Overview Developing Distributing ...

368 Part III: Advanced T-SQL Data Types and Querying Techniques Linking is a one-way confi guration between two servers. For exa ...

369 Chapter 15: Executing Distributed Queries 15 However, if the objects are not in the dbo schema, then you must use the approp ...

370 Part III: Advanced T-SQL Data Types and Querying Techniques This dialog has three pages; General, Security, and Server Optio ...

371 Chapter 15: Executing Distributed Queries 15 In a domain environment where users are connecting by using their domain creden ...

372 Part III: Advanced T-SQL Data Types and Querying Techniques type is not supported in distributed queries. So, change the las ...

373 Chapter 15: Executing Distributed Queries 15 context. If the @logicallogin is null, the setting applies to all nonmapped use ...

374 Part III: Advanced T-SQL Data Types and Querying Techniques Linking to Non-SQL Server Data Sources You have spent quite a bi ...

375 Chapter 15: Executing Distributed Queries 15 FIGURE 15-2 Creating a Named Range. The code samples used in this section are f ...

376 Part III: Advanced T-SQL Data Types and Querying Techniques With the link to the spreadsheet defi ned, you can now query the ...

377 Chapter 15: Executing Distributed Queries 15 AROUT Around the Horn Thomas Hardy BERGS Berglunds snabbkop Christina Berglund ...

378 Part III: Advanced T-SQL Data Types and Querying Techniques and processed. These types of queries are often called T-SQL dis ...

379 Chapter 15: Executing Distributed Queries 15 timeout, username and password, and catalog. The init string must defi ne the e ...

380 Part III: Advanced T-SQL Data Types and Querying Techniques Extended Properties=Excel 5.0' )...People SET FirstName = 'Cathe ...

381 Chapter 15: Executing Distributed Queries 15 The following example illustrates the same but against the Excel spreadsheet us ...

382 Part III: Advanced T-SQL Data Types and Querying Techniques Distributed Transaction Coordinator The responsibility of handli ...

383 Chapter 15: Executing Distributed Queries 15 SET LastName = 'Klein' WHERE ContactID = 55 UPDATE AvalonDev.AdventureWorks.Per ...

384 Part III: Advanced T-SQL Data Types and Querying Techniques This section, therefore, looks at several options for improving ...

385 Chapter 15: Executing Distributed Queries 15 Collations also play an important role in distributed queries. SQL Server suppo ...

386 Part III: Advanced T-SQL Data Types and Querying Techniques the result sets. For some scenarios, especially for Independent ...