Good Things to Know: How to kill processes in MS SQL Server and see blocking source

To see the blocking table inside MS SQL one can use this:

SELECT cmd, * FROM sys.sysprocesses WHERE blocked >0

Then if you want to remove the process just aim at those SPID code and shot to kill with:

KILL <spid_code>  -- yes kill is a command for those new to this :)