Update query causes Timeout sometimes

[msintome]

I have an irregular problem with SQL Server 7.0 where a single update query (within my ASP code) causes a Timeout error more often than not.

My query is as simple as "UPDATE tblCampaign SET [Status]='Completed' WHERE Campaign_ID=15"

And yet, some campaign_id's work, and others cause a timeout. Not only this particular UPDATE query, but others too.

Not only that, but tblCampaign is the only table to be experiencing this problem in the database.

SQL Server reports the database is healthy. Additionally, I can sometimes reboot the WEB SERVER (making the calls) and that resolves the problem (not always fixes the problem though).

Any ideas?

 

[RickCole]

Have you checked current activity when this is running to see if any other user has locks on the table which could be causing the problem.

Rick.