Keyset-driven Cursors Requirements for OLE DB Providers

Transact-SQL keyset-driven cursors can reference remote tables only if the following conditions are met:

• The distributed query must meet the requirements for SELECT statements used in a DECLARE CURSOR statement that declares the keyset-driven cursor. For more information about the Transact-SQL conditions for keyset-driven cursor support, see DECLARE CURSOR.
• All local tables in the query must have a unique index. The index of the remote table should be exposed through the INDEXES rowset of the IDBSchemaRowset interface.