Summary
The SQL Server Query Analyzer has evolved into a fairly full-featured SQL development and analysis tool. It has a number of useful and advanced features that go beyond simply being able to edit and submit queries to SQL Server.
The SQL Server Transact-SQL debugger has been through a number of difficult-to-use implementations, but this time around Microsoft has a winner. The 2000 SQL Debugger is well integrated into the Query Analyzer application, and it is extremely helpful for debugging complex stored procedures, user-defined functions, or triggers. The debugger can still be somewhat difficult to configure properly, but after you have the right pieces in place, it is easy to use.
In the next chapter, “Using the SQL Server Profiler,” ...
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.
