SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Getting Help on Query Analyzer

By Yakov Shlafman,

I read that SQL Server Books Online is very, very useful source of information if you know where to look for this information. After reading this article you will know how and where to get help on a selected topic and where to find the entire help book for Query Analyzer. To go directly to the topic of interest in the SQL Server Books Online - highlight a key word in Editor Pane or Results Pane and press Help icon in Tool Bar. The described procedure will open for you SQL Server Books Online on selected topic.

This is how to place Help icon on the Tool bar:

  1. Right click on the Tool bar to get Customize Toolbar window
  2. Select T-SQL Help icon
  3. Click Add button
  4. Use MoveUp or MoveDown button to position T_SQL Help icon in the desired spot.

To get help documents related to Query Analyzer:

  1. Press F1 to get a SQL Server Books Online Window
  2. Click Index tab
  3. Type in “SQL Q” (This is a shortcut for SQL QUERY ANALYZER)
  4. In the SQL Server Books Online Window double click on topic of interest.

If a topic contains multiple subtopics, double click on selected subtopic in the Topics Found window.

To turn on Extra keyboard Help in the SQL Query Analyzer

  1. Click Start button
  2. Control Panel
  3. Accessibility Options
  4. Check Show extra keyboard help in Programs
Now, in the SQL Query Analyzer, to open a drop down list from Menu bar use ALT key and an underscored letter. For example: ALT + Q to open QUERY selection list. This will help you to memorize all shortcuts.

To get all available information about Query Analyzer in one place – in SQL Server Books Online:

  1. Click T-SQL Help icon on toolbar
  2. Click Contents tab
  3. Click Using the SQL Server Tools
  4. Click User Interface Reference
  5. Click SQL Query Analyzer Help
  6. Read all topics (It’s only 51 printed pages)

You may search SQL Server Books Online for a specific topic. For example, let's search for a key word FAQ (Frequently Asked Questions):

  1. Click Search tab
  2. Type in the word FAQ in the 'Type in the word to search for' window
  3. Click List Topics button
  4. Double click on first topic 'Frequently Asked Questions'
  5. On the right pane double click on 'SQL Server Books Online FAQ'


To find more information about Query Analyzer please review the following links:
Help and Support http://support.microsoft.com/
The MSDN Library - http://msdn.microsoft.com/library/default.asp
SQL Server Magazine - http://www.windowsitpro.com/SQLServer/
SQLskills - http://www.sqlskills.com/links.asp
Windows XP Step by Step Tutorials - http://www.microsoft.com/enable/training/windowsxp/default.aspx and http://www.microsoft.com/enable/training/windowsxp/extrakeyboardhelp.aspx
SQLServerCentral.com - http://www.sqlservercentral.com/
Overview of SQL Query Analyzer - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/qryanlzr/qryanlzr_1zqq.asp
Microsoft Newsgroups, SQL Server - http://www.microsoft.com/technet/community/newsgroups/server/sql.mspx
MS SQL SERVER 2000 Technical Resources - http://www.microsoft.com/sql/techinfo/default.asp
SQL Server 2000 Books Online (Updated 2004) - http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Getting Started with SQL Server Books Online - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp
SQL Server 2000 Resource Kit - http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/default.mspx

Total article views: 9066 | Views in the last 30 days: 0
Related Articles

Starting Query Analyzer

Next in his series on Query Analyzer, Yakov Shlafman brings us a few ways that we can save more keys...


Block Users from using sql server query analyzer

Block Users from using sql server query analyzer


Block Users from using sql server query analyzer

Block Users from using sql server query analyzer


Query Analyzer Extended

SQL Server has the best client tools for a DBA of any RDBMS and SQL Server 2000 includes Query Analy...


Analyzing Data Storage - Ten SHOWCONTIG Queries

Analyzing the data storage in SQL Server databases is a bit of an art. It's a skill that takes some ...

sql server 7