title: How to detect whether a stored procedure is being run in SQL Server 2008 R2
body: <p>Is there a view or internal sp to do this?</p>
  
  <p>For example, I have a sp <code>spGoesOnForSomeTime</code>.</p>
  
  <p>If I kicked this off then some individual closes my computer down, how can I see whether this is still running or not?</p>
  
  <p>I realise I can use SQL Profiler and ActivityMonitor but I ultimately want to relay this information back through a web app.</p>
  
  <p>EDIT: Apologies, it is not a local connection.</p>