Enterprise Manager SQL2000 SP4 - table lock

  • jens-uwe.maass

    Newbie

    Points: 9

    Hi all,

    we have a old application in our company, which is using SQL Server 2000 SP4.

    Sometimes if a developer makes a SELECT on a table, this SELECT locks the table (but the SELECT was completed and only the result is shown) and everybody, who using this table in the app gets an Timeout.

    What can I do to solve this problem ?

    Thanks for all response

    cya

    Jens

  • MVDBA (Mike Vessey)

    SSC-Insane

    Points: 21757

    if you can risk gost data in your select statement then you could change the code to use NOLOCK

    Select * from table WITH (NOLOCK)

    there are certain risks involved (possible missing rows, or duplicate rows) but if you evaluate your environment and any actions you are going to drive from this data that you select, then you might consider it a worthwhile fix

    evaluate and consider carefully before implementing this though.

    MVDBA

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

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