Debugging with Microsoft Visual Studio and Visual Basic

In addition to the debugger provided with SQL Server Query Analyzer, a T-SQL debugger is provided with the Visual Studio development suite.

If you don't find SQL Server Debugging in the Control Panel, Add/Remove Programs dialog box, you have to add the software. Run the Visual Studio setup program, choose Server Applications and Tools, Launch BackOffice Installation Wizard, Install, Custom, and install SQL Server Debugging.

NOTE

You must have Visual Studio Version 6.0 to debug stored procedures. The T-SQL debugger in Visual Basic 5.0 or Visual Studio 97 does not support SQL Server 2000.

The enterprise edition of Visual Studio (Visual InterDev, Visual J++, and Visual C++) includes a debugger ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.

Start your free trial