Read Uncommitted

  • Does anyone know how to do

    SET TRANSACTION ISOLATION MODE READ UNCOMMITTED

    as part of a connection string?

    I dont care about dirty reads but I really want to avoid any locking issues.

     

  • You Can always pass the string as using Connection.execute method or us command object to do the same. This can be done after the connection is successfully opened.

  • I was looking for a way to do this when you dont have the source code for the application (i.e configuring a 3rd party application or a reporting tool).

    Maybe I should ask this in another forum?

  • "set transaction isolation level read uncommitted" is used to avoid waits for locked resources.

    table hint (NOLOCK) can be used to avoid read locks on resources.

    IMO you should contact your 3rd party to find out if and how you can provide parameters for the application to use this stuff.

    I don't know if you can add parameters to odbc or oledb configurations so the default connection type is read uncommitted.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply