Queries for linked servers

Once you have configured a linked server, you can use Transact-SQL to execute commands against the data source. To execute commands against that data source, you can use one of the following:

• reference the linked server directly

• pass-through mechanism

• heterogenous query

  Note: The account under which the SQL Server service runs must have read and execute permissions for the directory, and all subdirectories, in which PI SQL Client OLEDB is installed.