A query that accesses a linked server is causing me issues. When I traced the query from the remote server (Server B), I can see that the connection is using a cursor to return results to the remote server (Server A) where the query is run from. The sp_cursorfetch statement is processing in batches of 100 records, and apparently is generating a round-trip (to Server A) for each completion. However, when I issue the same query from Server A to Server B using OPENQUERY - no cursor is used, and the results are returned immediately. I've researched everything I can imagine, but with no results ... API Server Cursors link:http://msdn2.microsoft.com/en-us/library/aa172588(SQL.80).aspx It appears that this option is enabled/disabled at the provider level, but where? I'm using SQLOLEDB, with the following options configured at the server level (Allow Inprocess; Nested Queries).