title: How do I add breakpoints to a stored SQL Procedure for debugging?
body: <p>I am trying to debug a SQL procedure, and am using the following query to do so.</p>
  
  <pre><code>USE [database]
  GO
  
  DECLARE @return_value int
  
  EXEC    @return_value = [dbo].[Populate]
          @ssId = 201
  
  SELECT  'Return Value' = @return_value
  
  GO
  </code></pre>
  
  <p>The problem is, the procedure I am testing, (Populate) doesn't seem to stop at any of the breakpoints I assign to it. Is there a different way to add breakpoints such that I can follow the debugger? I am getting the following error: "Invalid line number specified with SQL breakpoint".</p>