KILLED/ROLLBACK query doesn't stop running

0 votes

2 answers

11883 views

sql-server sql-server-2008 sql-server-2012 kill

                          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.

Asked by Ezra P. (1 rep)

Jun 24, 2016, 11:48 AM
Last activity: Jun 25, 2016, 05:15 PM

KILLED/ROLLBACK query doesn't stop running

Related Questions