Home
|
Previous Page
|
Next Page
Managing Databases
>
Using Distributed Queries
In This Chapter
Overview of Distributed Queries
Coordinator and Participant in a Distributed Query
Configuring the Database Server to Use Distributed Queries
The Syntax of a Distributed Query
Accessing a Remote Server and Database
Database Name
Database Object Name
Specifying a Coserver ID (XPS)
Valid Statements for Accessing Remote Objects
Accessing Remote Tables
Table Permissions
Qualifying Table References
Other Remote Operations
Opening a Remote Database
Creating a Remote Database
Creating a Remote Synonym
Monitoring Distributed Queries
Server Environment and Distributed Queries
PDQPRIORITY Environment Variable
DEADLOCK_TIMEOUT
Database Access Restrictions
Transaction Processing
Isolation Levels
DEADLOCK_TIMEOUT and SET LOCK MODE
Two-phase Commit and Recovery
Cross Server Compatibility Issues (XPS)
BYTE and TEXT Data Types
Other Restrictions
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]