Debugging Stored Procedures in Visual Studio .NET

Visual Studio .NET was designed to support integrated debugging for SQL Server. Unfortunately, there are so many limitations on what a developer should and shouldn't do and the process for configuring debugging is convoluted enough that it is difficult to decipher how well this technology works. At this juncture I can tell you the benefit you are supposed to be able to derive, and I can also tell you I have not reliably and consistently been able to get integrated SQL debugging to work.

Visual Studio .NET was designed to allow you to debug SQL Server stored procedures in the Visual Studio .NET IDE using the same debugger you use to debug VB .NET code. The benefit here is powerful, and in Chapter ...

Get Visual Basic® .NET Power Coding now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.