Lock wait timeout exceeded; try restarting transaction even in single db single user
I am updating few databases all which I keep as one transaction using .net connector. The best part is that I can still run into this error of "Lock wait timeout exceeded; try restarting transaction" even though I am the only single soul using my database at that time. Any idea how to over come this problem. Thanks.
We also come across same problem and solved by freeing the sql connection which was utilized in previous queries.So there won't be any mistakes with your current queries and code.But you have to free the connections after usage for reusing them from the connection pool(Guess you are using one either directly or indirectly).
Thanks and Regards,
Saji T Sathian
Last edited by sajisathian; Sep 22, 2009 at 01:05.