System Tools
The Tools menu on the EM toolbar can be used to access additional tools not necessarily related to EM, but often accessed while working with EM.
Query Analyzer
Query Analyzer, introduced in SQL 7.0, has been revamped for SQL 2000 with the addition of an object browser and templates for object creation. From this tool, queries can be built, run, saved as scripts, and analyzed for performance. Refer to Chapters 6, “SQL Server Query Analyzer and SQL Debugger,” and 36, “Query Analysis,” for an in-depth look at this very powerful tool. Figure 4.20 shows the Query Analyzer.
Figure 4.20. The Query Analyzer.
SQL Profiler
Another tool that ...
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.
