Hi Everyone,

I am getting an error 1222: Lock request
time out period exceeded. This is happening approx once every couple of weeks. When trying to access Current activity. I have tried to trace blocs and locks but cant see anything that might be causing this problem. Can anyone help

Thanks

Ryan

What provider are you using to execute your query?

Is anybody setting @@LOCK_TIMEOUT? It is by default set to -1, indicating that processes are to indefinitely wait on a lock.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com