title: How to debug stored procedures in SQL server 2008 without CLR?
body: <p>How can I debug stored procedures in SQL Server 2008 management studio?</p>
  
  <p>I am trying to put a break point on SQL query and then press start debugging but I get an error that debugging cannot be started on my machine:</p>
  
  <pre><code>Debug cannot be started at &lt;machine name&gt;. 
  </code></pre>
  
  <p>I don't want to use CLR debugging.  How can I debug stored procedures?</p>