|
Expertise: Intermediate
Language: .NET
July 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:
- You need to have SQL Server Debugging components installed.
- You need the the appropriate debugging permissions on SQL Server.
Srinath MS
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible. Submit your tip here.
| 
