devxlogo

Debugging SQL Server Stored Procedures Through Visual Studio.NET

Debugging SQL Server Stored Procedures Through Visual Studio.NET

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:

  1. You need to have SQL Server Debugging components installed.
  2. You need the the appropriate debugging permissions on SQL Server.

devx-admin

Share the Post: