Results 1 to 4 of 4

Thread: lock

  1. #1
    Join Date
    May 2006
    Posts
    11

    Unanswered: lock

    Hi,
    i have a big problem , i work with sql 2000 on windows 2000.
    When user do a select against my database sqlserver lock all the table and nonoe can work.
    Haw can i change the isolation level for a ropw and for all the db.
    Thanks.

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    That's quite a heavy lock. What client/operation are you using?
    Too me, sounds someone restricted the database: a db can be restricted to allow one single user at a time. Did you check that? It's in the database properties, Options tab.

  3. #3
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    have you isolated the problematic code using profiler? somebody using nasty table hint or big long transaction? got code?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Sounds like your user's query is doing a table scan. Get his query, and see if any indexes will help it. An index is a pre-requisite for row locking.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •