title: Unable to step into stored procedure inside stored procedure - SQL debugging using VS2010 and SQL Server
body: <p>I'm checking out the SQL Debugger using Visual Studio 2010 (connecting to a SQL 2005 Enterprise Server), and I can successfully debug a stored procedure by going to Server Explorer -> Right clicking on the procedure -> "Step Into Stored Procedure".</p>
  
  <p>However, once I'm in, I can't step into or set any breakpoints inside any subsequent function or stored procedure calls.  See the example below:<br>
  <code>esp_StoredProc</code> calls <code>esp_AnotherStoredProc</code>, but I can't set a breakpoint inside of <code>esp_AnotherStoredProc</code> or step into it during my debug session.</p>
  
  <p>Is this a limitation of SQL debugging, or perhaps a limitation of my configuration or how I'm debugging things?</p>
  
  <pre><code>esp_StoredProc:
  
  -- do something
  
  -- do something else
  
  -- call esp_AnotherStoredProc
  </code></pre>