O'Reilly logo

Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Debugging

The best tool for debugging Transact-SQL stored procedures comes right in the SQL Server box. Query Analyzer now includes a full-featured stored procedure debugger. You can set breakpoints, establish watches, and generally do what debuggers are designed to do—debug code. You can debug procedures from the current version of SQL Server back through SQL Server 6.5 Service Pack 2.

The interface by which this occurs is known as the SQL Server Debug Interface, or SDI for short. It was originally introduced with SQL Server 6.5 and has since been completely integrated with Visual Studio and, now, Query Analyzer.

Setup and Security Issues

You should run SQL Server under a user account, not the LocalSystem account, when debugging. Running under ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required