blocking even when the code is set transaction level is set to read uncommitted?

  • I have a sproc which is set to read uncommited but still is blocking. Any thoughts?

  • Does it just Select stuff, or does it do any Update/Insert/Delete actions? If it does more than just Select, then it will still generate locks and can still block things.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

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