title: Custom sp_who without granting view server state
body: <p>I need a stored procedure that I can give to a group of users that will allow them to see all running processes (like <code>sp_who</code>), but I don't want these users to have <code>VIEW SERVER STATE</code> permissions as this will expose too much metadata.</p>
  
  <p>I also need to allow the users to kill processes.</p>
  
  <p>This is for a dev server dedicated to this group, and my goal is to allow this functionality without exposing more info than necessary.</p>
  
  <p>Anyone have any ideas?</p>
  
  <p>So far I've tried creating a stored procedure that calls <code>sp_who</code> as me (DBA), but the results only show the callers current process.</p>
  
  <p>TYIA!!!</p>