Share via


How to: Set Options for Query Execution and Results

You can set options to control how your scripts and queries are executed in the Transact-SQL (T-SQL) editor. For example, you can restrict how many rows will be returned or how long to wait for results. You can set options that apply to all new editor sessions that are created but do not affect existing instances of the T-SQL editor.

To set options for query execution and results

  1. On the Tools menu, click Options.

    The Options dialog box appears.

  2. Expand the Database Tools node, and then expand the T-SQL Editor node.

    The Query Execution and Query Results nodes appear.

  3. Click the node that contains the options that you want to configure.

    The Query Execution node contains three sub-nodes:

    The Query Results node contains three sub-nodes:

See Also

Tasks

How to: Execute a Query
How to: Start the Transact-SQL Editor

Concepts

Query Results Overview