How to see open process and kill processes SSMS DB

Open SSMS :

Run the following command :

exec sp_who

i.e this will show all the processes in the SSMS

To kill the process select PID and write the following command

kill 52        [In this case PID is 52]

Set database from SINGLE USER mode to MULTI USER :

ALTER DATABASE BARDABARD

SET MULTI_USER;

GO