Kill a lock process
filed in sql on Jul.18, 2008
The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server:
1
2
3
4
–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 [...]
