title: Forcing a specific stored procedure to stop after 30 seconds: I do not want to reconfigure the timeout of the whole DB
body: <p>(The reason <em>why</em> I need the following are unimportant)</p>
  
  <p>What I'd like to do is adjust the following so that it executes the stored procedure, which usually takes 30 minutes, but then the procedure stops after a set time of 60 seconds - effectively the same as if I am in <code>SSMS</code> running the procedure and press the cancel button after 60 seconds.</p>
  
  <p>I don't want to reconfigure the whole db so that every other long running stored procedure times out after 30 seconds - only the specific procedure <code>TESTexecuteLongRunningProc</code>.</p>
  
  <p>Here is the test procedure being called:</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[TESTlongRunningProc] 
  AS
  BEGIN
  
     --placeholder that represents the long-running proc
     WAITFOR DELAY '00:30:00';
  
  END;
  </code></pre>
  
  <p>This is the proc I would like to adjust so it cancels itself after 60 seconds:</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[TESTexecuteLongRunningProc] 
  AS
  BEGIN
  
      EXECUTE WH.dbo.TESTlongRunningProc;
  
      --&gt;&gt;here I would like some code that cancels TESTexecuteLongRunningProc after 60 seconds
  
  END;
  </code></pre>