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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: