SQL Server: Connecting Windows Process to SQL SPID’S

Just a quick note:

The SQL Server command select * from master..sysprocesses shows the linkage between the Windows Process and SQL Server Process (SPID).

This useful if you want to kill the SQL command without kiling the Windows process.

By the way, the column is hostprocess for the Windows process id.