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 report.
spid 55: Transaction rollback in progress. Estimated rollback completion: 70% Estimated time left: 15 seconds.

Leave A Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.