How to set default transaction isolation?

dmajkic · Post by **dmajkic** » Wed 04 Aug 2010 14:42

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?

Dimon · Post by **Dimon** » Thu 05 Aug 2010 08:20

Use the following code:

Code: Select all

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