Database table Locks

Feb 14, 2011 at 10:08 AM
Edited Feb 14, 2011 at 10:30 AM


Does anyone else ever experience table locks? I've had this twice now...

As i dont get it all the time its a bit hard to track down but from memory its when I'm debugging and recompiling the code quite often. It just shows up as a:


SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.

Further investigation with activity monitor in SSMS shows that I have a open transaction.

I assume this is caused via stepping through the code during debug and then stoping the dubugger?