Absolutley fantastic Sol_Web_Solutions! That script was an absolute winner!

Managed to sort the problem. I have 2 nodes A and B. I shifted all resources to A (which again failed with the error above - the sql error log...

Hi There,

Was anyone able to solve this problem? I'm having the same problem now and its doing my head in!

Any help woud be great!

Cheers

Sam

Cheers for the reply and i'll monitor that more closely aswell. Is sys.dm_exec_sessions available on SQL Server 2000?

I concur! I am having major problems with one of your applications at the moment and this will be a good way determining whether deadlocks are correlating to any of...