Cancel a SQL Server Query
November 29, 2007 12:53 PM Subscribe
Please help me understand what happens when I click the cancel query button in SQL Server Management Studio.
Please help me understand what happens when I click the cancel query button in SQL Server Management Studio.
I was running a delete query in SQL Server 2005 on a pretty slow machine with low resources on a pretty big database table. After about 2.5 hours, I got a message that I was running low on disk space and when I checked, drive C had 5MB free out of 75GB.
Anyway, I went to cancel the query and here I sit, one hour later and it still says "Canceling Query". Am I going to have to wait another hour and a half for this? Will any of the deletes have been committed or did I just waste 3 and a half hours of time?
Please help me understand what happens when I click the cancel query button in SQL Server Management Studio.
I was running a delete query in SQL Server 2005 on a pretty slow machine with low resources on a pretty big database table. After about 2.5 hours, I got a message that I was running low on disk space and when I checked, drive C had 5MB free out of 75GB.
Anyway, I went to cancel the query and here I sit, one hour later and it still says "Canceling Query". Am I going to have to wait another hour and a half for this? Will any of the deletes have been committed or did I just waste 3 and a half hours of time?
Also here's some info to get your disk space back: http://support.microsoft.com/?kbid=873235
posted by Emanuel at 1:34 PM on November 29, 2007
posted by Emanuel at 1:34 PM on November 29, 2007
Response by poster: Thanks Emanuel...
I wound up just dropping the table altogether and recreating it.
posted by smithygreg at 2:14 PM on November 29, 2007
I wound up just dropping the table altogether and recreating it.
posted by smithygreg at 2:14 PM on November 29, 2007
« Older Please help my find a pair of headphones that... | How do I configure Movable Type's email settings... Newer »
This thread is closed to new comments.
posted by Emanuel at 1:31 PM on November 29, 2007