I am using WF for a read only application. The db is SQL Server 2000. I have detected that transactions are being used. This does not make sense. Its taking too much time to committ these read only transactions.
So I am trying to configure the adapter to use:
ENGINE SQLMSS SET TRANSACTIONS AUTOCOMMITED and while Im at it ENGINE SQLMSS SET CURSORS CLIENT to optimize the cursor activity that is occurring.
I place these statements in the edasprof.prf file and restart the server. But transactions are still being generated. What am I doing wrong?
Thank you,

Hi there

You have a spelling mistake in your statement, you are missing a T in COMMITTED.
The below should work.

ENGINE SQLMSS SET TRANSACTIONS AUTOCOMMITTED.