Below is a SQL script that I use all the time when it comes down to hung procedures and any unwanted processes that are left open. This below T-SQL could also be turned into a procedure quite easily and used as a cleanup job before running any backups. DECLARE @p_SPID int, @p_SQL nvarchar(2000), @dbName nvarchar(100) [...]