I had this issue with an SP that was using BCP just to output a file.

On the SQL Server, I ended the bcp.exe process in Task Manager, and the SPID vanished.