SQL QUERY ANALYZER TOOLS V2K The new SQL Query Analyzer (ISQL/W) offers several updated features. It now allows you to define Query Shortcuts/Hotkeys and a tool menu. Open ISQL/W and log in to the SQL Server. This feature appears within the Tools | Customize menu. QUERY SHORTCUTS/HOTKEYS (CUSTOM TAB) This new functionality comes with three predefined queries: Alt+F1 = sp_help Ctrl + 1 = sp_who Ctrl + 2 = sp_lock You may already use these system stored procedures; you can now define your own procedure or queries, as well. Assume that you want to assign [Crtl][F1] to an often-used query. Simply type the following query: SELECT name FROM master.dbo.sysobjects ORDER BY name Apply the changes. When [Ctrl][F1] is depressed, the previous query is executed. This is useful if you have a series of queries that you frequently use. MENU CONTENTS (TOOLS TAB) On the Tools tab, you have the ability to define a tool that is launched independently of the ISQL/W. This is useful and only limited by your imagination. Assume, for instance, that you are writing a query, which requires complex number crunching. You can double-check the results returned from the query against your own calculations by launching the Microsoft Calculator from this customized menu without the necessity of locating the Calculator icon from your Windows Desktop. Click the Add button and type Calculator. Browse to find the Calc.exe program. You can now quickly access the Calculator from the Tools menu. ---------------------------------------