title: Unable to debug SQL Server 2008 Stored Procedure from SQL Management Studio
body: <p>I'm trying to debug a stored proc on a SQL Server 2008 server from my development workstation.</p>
  
  <p>The server is running SQL Server 2008 (10.0.2531.0) and I have SQL Server 2008 R2 on my workstation (10.50.1600.1).</p>
  
  <p>I'm 99% certain that this combination has worked in the past, but something has changed recently so that it no longer works.  I know I've been able to debug against this server in the past.</p>
  
  <p>When I hit the "Debug" button in SQL Management Studio, the proc just runs.  Previously, it would step into the proc and stop on the first line.  Even if I set a breakpoint in the proc the debugger never stops.</p>
  
  <p>If I remote desktop to the SQL server I am able to debug the proc using SQL Management Studio on the server.</p>
  
  <p>What configuration settings and/or security rights should I look at to troubleshoot this?</p>
  
  <p>Is there any sort of debugger log that I could view to investigate this?</p>