Cacher is the code snippet organizer for pro developers

DECLARE @dbName nvarchar(max), @sql nvarchar(max)
SELECT @dbName = N'__DBNAME__', @sql = N''

SELECT @sql = @sql + N'KILL ' + CONVERT(nvarchar(max), spid) + ';'
FROM master..sysprocesses
WHERE dbid = DB_ID(@dbName)

--EXEC sp_executesql @sql