title: how can effectively debug stored procedures in visual studio
body: <p>ive been debugging sql 2005 stored procedures in visual studio 2005 and find it really frustrating that i can't run a sql query while stepping through the code. </p>
  
  <p>specifically my main issues are...</p>
  
  <ul>
  <li><p>if my SP inserts/updates to temp tables then i cant query those tables while debugging. would be cool if i could use the immediate window to run sql. </p></li>
  <li><p>if my SP is run under a transaction i then again cant query any tables it effects while debugging.  even if i switch over to sql management studio and run a query for uncommitted data.</p></li>
  </ul>
  
  <p>only thing i can check in the debugger are local variables used in the SP which isnt all that helpful.</p>
  
  <p>anyone know of a better way to debug? is this any better in VS.net 2008 or 2010?</p>