Kill blocking processes on a database

Kill-sql-locks

--- Kill blocked processes on a database
DECLARE @databasename nvarchar(50)
SET @databasename = N'Datbase_Name'
-- SET @databasename = DB_NAME()

DECLARE @Sql varchar(max)
SET @Sql = ''

SELECT @Sql = @Sql + 'Kill ' + Convert(varchar, SPId) + ';'
FROM master.dbo.sysprocesses
WHERE DBId = DB_ID(@databasename) AND SPId <> @@spid
and spid IN (SELECT blocked FROM master.dbo.sysprocesses)

--You can see the kill Processes ID
SELECT @Sql

--Kill the Processes
EXEC(@Sql)