Chapter 6. SQL Server Query Analyzer and SQL Debugger

by Ray Rankins and Bennett McEwan

IN THIS CHAPTER

  • Query Analyzer

  • The SQL Debugger

SQL Enterprise Manager (SQL EM) is a fine tool for creating and managing databases and database objects, as well as managing and monitoring SQL Server. However, there are times when you'll want to write and execute SQL directly. For example, SQL EM provides the ability to create and modify stored procedures, triggers, functions, and views from within the database browser, but the editor window it provides is very simplistic—no search/replace capability, no ability to save or open a file from within the editor, and no way to execute and test your SQL code.

Fortunately, Microsoft provides SQL Query Analyzer. The ...

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