1. Find the negative SPID number.
2. For e.g. is SPID number is -2 then run the below T-SQL
use master
go
select req_transactionUOW from syslockinfo where req_spid = -2
go
3. You will get a hexadecimal value with the above syntax and then run the below command.
KILL 'FE4A57F2-28C5-44F9-8416-B08760DFE7E9'
By this process you will be able to kill negative SPID.
2. For e.g. is SPID number is -2 then run the below T-SQL
use master
go
select req_transactionUOW from syslockinfo where req_spid = -2
go
3. You will get a hexadecimal value with the above syntax and then run the below command.
KILL 'FE4A57F2-28C5-44F9-8416-B08760DFE7E9'
By this process you will be able to kill negative SPID.
No comments:
Post a Comment