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开发者_如何学JAVA 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".

Actually, if you have SQL Server 2008, you can once again debug in Management Studio.

Each of these articles will take you through it step by step, with screenshots. It could hardly be easier.

SQL Server 2008: The Debugger is back

T-SQL Debugger is back in SQL Server 2008 ... debugging now made easy

New Features in SQL Server 2008 Management Studio

Follow these tutorials:

Debugging Stored Procedures in SQL Server 2005

Debugging SQL Server CLR functions, triggers and stored procedures

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.