Community

How to kill a negative SPID (like SPID -2 or -3) in SQL Server?

(Rohit Garg) Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all the user sessions & stop the application but still we are facing this issue.

Read More - Register for Free Membership