The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server: –This example shows how to terminate SPID 55. KILL 55 –This example generates a status of the rollback process for the specific spid. KILL 55 WITH STATUSONLY –This is the progress… Continue reading →