It worked for me both on 2005 and 2008. Thanks so much !!!

Got you... Your screenshot explained me why I was not getting the results. I assume that a google search happens here.. And we have a proxy to disable sites other...

Kenneth,

Thanks for your immediate reply.. But the database is not in the Suspect Mode.. And I must confess that it is my negligence as I am getting this message for...

David.. thank you very much explaining what exactly I was desperately looking for !!! But all you guys were too good good and the concepts are crystal clear now !!!...

Thank you very much for all your efforts to make my concept clear... But there are a few things still confusing me..

Taking the same scenario which I have explained in...

Can anyone help me with the above mentioned topic?

Many thanks in advance..

Sandhya

Thanks John..

We have BMC Patrol installed on the servers and through the Patrol alerts only I started noticing the blocks. And most of the time the waittype is LATCH_EX

and at...

Thanks John for your reply..

The problem is still hanging for me.. Using the dbcc inputbuffer results with the EventInfo sp_prepexec;1.

If the problem is with I/O resource is there anything we...

Thank you very much for all of you to make my concept clear !!!!