Page 1 of 1

How to set default transaction isolation?

Posted: Wed 04 Aug 2010 14:42
by dmajkic
I need to create monitoring app that will just scan and show some tables, and I don't want to interfere with other users.

How can I set default transaction isolation to ReadUncommited?

Is there a way to set this via TSQLConnectionpa rameters?

Posted: Thu 05 Aug 2010 08:20
by Dimon
Use the following code:

Code: Select all

CRSQLConnection.Params.Values['DevartSQLServer TransIsolation'] := 'dirtyread';