https://www.varindersandhu.in/2011/10/01/sql-server-sql-scripts-to-find-and-kill-all-the-blocked-process-in-a-database/
SQL Server – SQL Scripts to find and Kill all the Blocked Process in a database