alas!! I dont have specs for it and the deveper has long left widout documenting things.

I know its hard to optimize this sp. The child SP is fine and runs...

The time out is set to 0(unlimited).

Also when I run the sp from QA it takes approx 3-4 min to exe successfully, but when this sp is called by my...

I have tried modifying the cursor to loop but could not change much ...

some developer has written it .. and it has come to me for optimization.

still the query takes...

Thanks for the response.

Is there something that can work in SQL 2000.

I just need to find sp/query running slow in 2k

Hi Ian

Can we have similar kinda query/SP for SQL 2000.

Also can you brief us about DMV.

Thanks

Hi

I got error while exec the query

Im on SQL 2005 Sp2

Msg 170, Level 15, State 1, Procedure dba_QueryTimeDelta, Line 43

Line 43: Incorrect syntax near 'MAX'.

Msg 156, Level 15,...

Dear

It is the error : SQL exception..

It is the Stack trace

The space available on disk is in GB and RAM is 2GB.

The process doesn't need to be killed at back end but from task manager or closing the application from...

Hi

SQL 2000 Dev Ed SP1

Application is web based and when it hangs.. we need to close the application either from task manager or from top.