• Post Reply Bookmark Topic Watch Topic
  • New Topic

Read Uncommitted in Sql Server

Luke Zechariah
Ranch Hand
Posts: 129
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Our application is using jtds driver and the database is MS Sql Server 2000. We are having 2 processes say ProcessA and ProcessB accessing a table Action1.

The problem we are facing is it either deadlocks or time-outs the resources waiting. How do we programatically code the isolation level to query with an "Uncommitted Read"?
What I am trying to find is an sql query or code wise alteration of the following query:

select a.docControlID from action1 a WHERE a.ID = 49270

Although it is a simple query there is another ProcessB which is trying to update the Action1 table parallely. The dba says we have a row level locking on the db. So please let me know of any suggestions to be made on the code as well on the database also.

Thank you for your time.
Paul Campbell
Ranch Hand
Posts: 338
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!