Posted by govus on 01/23/07 16:24

Hi everyone-
I'm using the Microsoft JDBC driver for SQL Server 2000 and I'm trying
to avoid using server cursors.

Is there a way to guarantee that every query will not create a
server-side ResultSet with a cursor? In other words, I want every
ResultSet to be loaded into the client's (the web server's) memory.

Does setting the "selectMethod" connection property guarantee this?

Does SQL Server automatically decide which method is best and if so,
what is the default choice?

I would appreciate any insight. Thanks in advance!

[Back to original message]