Update Time Out?

[mbailey]

I am using ASP to insert/delete/update rows into a very simple SQL
Server database (2000).
When a certain amount of text (as little as 1000 chars) is inserted to
the table (the insert works fine) ANY update call to that row will time
out.
I can set the time out for 5 minutes and it still times out udating
each field to to null.
Woudl this have anything to do with row locking?

Has any one ran into this problem and solved it?

Thank for your help,
MB

[Erland Sommarskog]

mbailey (ma*********@gmail.com) writes:

I am using ASP to insert/delete/update rows into a very simple SQL
Server database (2000).
When a certain amount of text (as little as 1000 chars) is inserted to
the table (the insert works fine) ANY update call to that row will time
out.
I can set the time out for 5 minutes and it still times out udating
each field to to null.
Woudl this have anything to do with row locking?

It does indeed sound like a blocking issue.

Run sp_who from Query Analyzer when you encounter this situation.
Look at the Blk column. If this column has a non-zero value, the spid
on this row is blocked by the spid in Blk. Next you can use DBCC
INPUTBUFFER to find out what the blocking spid may be up to.

From the description, it sounds that you leave uncommitted transactions
behind.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[mbailey]

Thank you Erland.
A select statement was blocking the update...and your advice helped
alot.

Thanks Again
MB

[Erland Sommarskog]

mbailey (ma*********@gmail.com) writes:

Thank you Erland.
A select statement was blocking the update...and your advice helped
alot.

Glad to hear that you were able to track down the problem!
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp