Enterprise Manager SQL2000 SP4

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Service Packs » Enterprise Manager SQL2000 SP4 - table lock

Enterprise Manager SQL2000 SP4 - table lock

Rate Topic

Display Mode

Topic Options

Author

Message

jens-uwe.maass

Posted Thursday, April 09, 2009 2:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 9:05 AM
Points: 1, Visits: 6

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

Post #693795

MVDBA

Posted Thursday, April 09, 2009 2:46 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:15 AM
Points: 2,261, Visits: 758

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

Post #693804

« Prev Topic | Next Topic »

Permissions