[dba-SQLServer] gracefully shut down a process

You can issue a kill spid for the running process but th

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
>