Kill the Bill SPID.
We use sp_who2 to find out all the sesions existing in the server , and to find the blocking SPID we need to execute select * from sys.sysprocesses where spid0; and then kill the Main spid blocking by using KILL , and then to know when is the rollback process complete ? check using KILL with status only; and also we can use SELECT blocking_session_id, *
FROM sys.dm_exec_requests query to find out what is the blocked ids.
Leave a comment