19 reputation
3
bio website
location
age
visits member for 2 years
seen Dec 19 '12 at 19:32

Dec
14
awarded  Commentator
Dec
14
comment Select blocking issue
I am willing to avoid same situation. If I can use lock timeout then there will be no blocking. I guess!!
Dec
14
comment Select blocking issue
@Mark Storey-Smith It worked for few hours but again issue raised. Perhaps, locks were removed by detaching & attaching
Dec
14
comment Select blocking issue
Is there a way to add timeout for UPDLOCK ??
Dec
14
comment Select blocking issue
Thanks, I will try it & let u know
Dec
14
comment Select blocking issue
Do you think, changing query like this can help fixing issue? Is issue related to query written in different way?
Dec
14
comment Select blocking issue
We have software which scrape info for product like images, data from forum etc. SOftware run 24 hours
Dec
14
awarded  Editor
Dec
14
comment Select blocking issue
Problem has started few days ago, companies has around 3000 records, products has around 60000 & tblcompanydetail has around 240,000 records.
Dec
14
comment Select blocking issue
I have reposted my procedure, I missed on statement before
Dec
14
revised Select blocking issue
added 298 characters in body
Dec
14
asked Select blocking issue
Dec
13
awarded  Student