Quite a handy script if you want to clear out ALL spids connected to a database.
USE master
go
DECLARE @dbname sysname
SET @dbname = ‘yourdbname’
DECLARE @spid int
SELECT @spid = min(spid)
FROM master.dbo.sysprocesses
WHERE dbid = db_id(@dbname)
WHILE @spid IS NOT NULL
BEGIN
EXECUTE (‘KILL ‘ + @spid)
SELECT @spid = min(spid)
FROM master.dbo.sysprocesses
WHERE dbid = db_id(@dbname) AND spid > @spid
END
