title: Failure to debug T-SQL or stored procedures
body: <p>Sql Server 2008 SP2 </p>
  
  <p>In Management Studio 2008 after setting a breakpoint on any piece of T-SQL and presssing debug button: </p>
  
  <pre><code>TITLE: Microsoft SQL Server Management Studio
  ------------------------------
  
  Failed to start debugger
  
  ------------------------------
  ADDITIONAL INFORMATION:
  
  Data is Null. This method or property cannot be called on Null values. (System.Data)
  
  ------------------------------
  BUTTONS:
  
  OK
  ------------------------------
  </code></pre>
  
  <p>After pressing OK.</p>
  
  <pre><code>---------------------------
  Microsoft SQL Server Management Studio
  ---------------------------
  Unable to start program 'MSSQL:://(local)/master/sys/=0'.
  
  ---------------------------
  OK   
  ---------------------------
  </code></pre>
  
  <p>In Visual Studio 2010</p>
  
  <pre><code>---------------------------
  Microsoft Visual Studio
  ---------------------------
  The Transact-SQL debugging session could not be started on the remote host. Verify that the instance of SQL Server is configured to enable Transact-SQL debugging.
  ---------------------------
  OK   
  ---------------------------
  </code></pre>
  
  <p>Followed advice in other thread to apply SP2 for SQL Server 2008 without success. Server is actually (local) , don't know why Visual Studio reports it as remote.</p>