Share via

Transact-SQL Editor Options (Query Results/General)

  • Article

Use this page to specify how results are handled when you execute a query. If you make changes with the Options dialog box, they will apply only to new instances of the editor. Existing instances will maintain the global settings that were in effect when that instance of the editor was created. If you make changes with the Query Options dialog box, they will apply only to the active Transact-SQL editor window. For more information, see How to: Set Options for Query Execution and Results.

  • Default destination for results
    You can specify whether the query results should appear by default in the grid, as text, or to a file. Results appear in the grid by default.

  • Default location for saving query results
    You can specify the default location where files will be created when you save the results of a query or when you save grid results to a .csv file. Files are created in your "My Documents" folder by default.

  • Play the Windows default beep when a query batch completes
    If you select this check box, the Windows beep plays when a script finishes executing. No beep plays by default.

  • Reset to Default
    You can click this button to reset these options to their default states.

See Also

Tasks

How to: Set Options for Query Execution and Results

How to: Control the Gathering and Display of Client Statistics

Reference

Transact-SQL Editor Options (Editor Tab and Status Bar)

Transact-SQL Editor Options (Query Execution/General)

Transact-SQL Editor Options (Query Execution/Advanced)

Transact-SQL Editor Options (Query Execution/ANSI)

Transact-SQL Editor Options (Query Results/Grid)

Transact-SQL Editor Options (Query Results/Text)

Concepts

Editing Database Scripts and Objects with the Transact-SQL Editor