[dba-SQLServer] gracefully shut down a process

jwcolby jwcolby at colbyconsulting.com
Thu Sep 24 09:34:24 CDT 2009

Is there any way to gracefully shut down a running query QUICKLY?

I have a stored procedure running which really should have completed long ago.  This SP calculates a 
hash value for a set of concatenated text fields and stores the result back into a binary hash field.

I ran this thing 3 times today on other tables of roughly the same number of records and they 
completed in perhaps 15 minutes.  For whatever reason, this one has been running 1.5 hours.  These 
process bogs down the server such that very little real work can get done with it running.

So I need to tell SQL Server to just stop!  Store what you have calculated and stop!

Any way to do this?  Without killing the table being written to.

John W. Colby

More information about the dba-SQLServer mailing list