What does Prepare Method (SPOption) do?

This option is specific to the TDS-based Driver for Microsoft SQL Server & Sybase ASE/ASA. It determines whether the driver creates stored procedures on the server for SQLPrepare() calls.

GUI Setting	Options Setting	Effect
Full	-O 2	Stored procedures are created for every call to SQLPrepare(). This can result in decreased performance when processing statements that do not contain parameters.
Partial	-O 1	Default. Stored procedures are created if the statement contains parameters. Otherwise, the statement is cached by the driver and run directly at the time of SQLExecute().
None	-O 0	Stored procedures are never created. The driver caches the statement, executes it directly at the time of SQLExecute(), and reports any syntax or similar errors at the time of SQLExecute().