[dba-SQLServer] gracefully shut down a process

Arg sorry I sent the previous message too early

I was saying if you kill the spid you can stop the process but then  
you might have to wait through the rollback for the changes to be  
undone. Sometimes if what you were running involves a cursor the only  
solution might be to restatt the SQL service.

Sent from my mobile

On Sep 24, 2009, at 7:34 AM, jwcolby <jwcolby at colbyconsulting.com>  
wrote:

> 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
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>