We have locked session, and trying to kill using command kill <spid> in query analyzer, but the session is not getting killed.
when we right click and c the properties of the spid it says sp_execute.
pls help us in killing this.
Is the problem with the optimization ? If so, do a dbcc checktable/checkdb to see if there is corruption. If it is an index issue, you can run dbcc dbreindex or drop/recreate the indexes. Do you know where the problem exists within the optimization ?