Hi,

I have an application where by some 100 connections are made to my SQL Server.
But sometimes it runs for days without hanging and sometimes within 5 mins it hangs up.

Is there any way to check what the server is doing when it is hanging . I would like to
Check if there is any deadlock condition... I am using SQL Server 7.0

Thanks in advance

regs
Vikram

MS Sql Server LazyDBA home page