Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Customizing the Tools Menu

SQL Server 2000

You can customize SQL Query Analyzer by adding commands to the Tools menu. For example, you can add executables like Notepad or osql, or the names of documents.

To add commands to the Tools menu

  1. On the Tools menu, click Customize.

  2. In the Customize dialog box, click the Tools tab.

  3. Click the add button. In the Menu contents list, type the name to appear on the Tools menu. This might be the name of an executable or the name of a document to be opened. Use the up and down arrows to position the name in the menu.

  4. In the Command box, enter the name and location of the file to be executed. You can use the browse (...) button to find the directory in which it resides.

    For example, to execute osql, enter this:

    C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe

    If using Microsoft® Windows NT® and want to specify Notepad, enter this:

  5. Enter any arguments for the command in the Arguments box. For example, if the command is osql, you might specify the options –Usa -Psapassword.

    If the command is Notepad and you want the menu command to invoke a new document, leave this box blank. If you want to open a specific document in Notepad, specify the name of the document here.

  6. In the Initial Directory box, enter the location from which the command will be executed.
© 2015 Microsoft