Reputation: 7150

How do I add breakpoints to a stored SQL Procedure for debugging?

I am trying to debug a SQL procedure, and am using the following query to do so.

USE [database]
GO

DECLARE @return_value int

EXEC    @return_value = [dbo].[Populate]
        @ssId = 201

SELECT  'Return Value' = @return_value

GO

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".

Upvotes: 10

Answers (3)

Jaseer

Reputation: 1

1 Make a connection to a database. 2 Right-click the stored procedure, user-defined function, or trigger you want to work with and choose Open from the shortcut menu.

To insert a break point

1.Right-click the line of SQL syntax in the editor window where you want to insert a breakpoints. 2.Point to Break point and then click Insert Break point.

Upvotes: 0