Debug procedures in SQL 2005

Steps to Debug a stored procedure in sql 2005

1. Open the Microsoft Visual Studio 2005
2. Select Server Explorer option from Menu as follows:



3. From the Data Connections node, 'Add connection'.



4. Expand the data connection navigate to the Stored Procedures node.

5. Select the intended SP to be debugged.

6. Right click and to view the Stored procedure.

7. Place a break point on the intended line of code where debugging needs to be started.




10. Right click on the stored procedure select 'Step-Into Stored Procedure' as shown below.



11. This action brings parameter screen.



12. Enter the needful values and click Ok.