title: SQL Server debugging stored procedure using old version of code
body: <p>I have a stored procedure in SQL Server, and I'm trying to debug it using SSMS. Here's my process:</p>
  
  <ol>
  <li>Change the stored procedure and execute</li>
  <li>Run the stored procedure in debug mode to observe the effects of my change - this opens a new tab in SSMS for debugging</li>
  <li>Finish the debug session, change the stored procedure and re-execute</li>
  </ol>
  
  <p>It would appear that if I don't close the tab created in step 2 then the debugger uses the previous version of the stored procedure. Is this a known issue with debugging in SSMS and if so, is there a workaround or fix for it?</p>