thanx..grasshoper , but that didnt help, what i actually need is an alert , whenever the deadlock exceeds 5 min, call it a deadlock or server hang up, but..in my...

hi everybody, with some minor changes as suggested by you ppl, the query executed in 4 min :D, here is the updated query, the problem is that we would be...

any you u advice me, how do i look, whether the correct index has been used rather..?:)

this select query uses many tables , do you want all the table and index definitions...cant you see the exec plan and be particular as to which particular table/index is...