Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: .NET
Expertise: Intermediate
Jul 15, 2008

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.

Srinath MS
Thanks for your registration, follow us on our social networks to keep up-to-date