Re: A timeout occurred while attempting to lock x

2006-08-16 Thread Al Musella, DPM
I had the same problem once... I know you aren't supposed to do this, but I had to make a fast change to a database table and opened up the live sql table in enterprise manager.. I made the change fast, then got distracted and left the table open.. I got a bunch of complains about the entire

RE: A timeout occurred while attempting to lock x

2006-08-15 Thread kola.oyedeji
Neil Could be that you have a portion of code which normally doesn't take a while to run but for some reason is taking longer than usual and hence the lock is timing out. You should be able to find out where the lock is timing out and examine what the code is doing, especially if its locking