I've tried to kill a query on ms sql server management studio. Now it has the status killed/rollback.
When I use: kill 74 with statusonly it doesn't make any progress. It is still at 0%. How can I delete this query without restarting the sql server?
I will really appreciate all your answers.