title: How to stop XP_cmdshell (kill/Rollback)
body: <p>I observed that xp_cmdshell is in KILLED/ROLLBACK state in my SQL server and consuming memory from tempdb.</p>
  <p>I tried to get the PID for this session id and the source server from which it was generated, I could not find the PID in source server tasklist.</p>
  <p>Is there any way to stop this xp_cmdshell without restarting SQL server.</p>