To debug SQL server stored prodecures, use the Server Explorer to select the SQL Server database, select the desired stored procedure and set a breakpoint. Then run the code. After the compiler stops on the breakpoint, you can perform the step-in, step-out, and other common debugging procedures.
Please note:
- You need to have SQL Server Debugging components installed.
- You need the the appropriate debugging permissions on SQL Server.