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 General node. This node contains settings that relate to row counts, text size, time-outs, and batch separators. For more information, see Options (Database Tools/T-SQL Editor/Query Execution/General Page).

   • The Advanced node. This node contains more advanced settings, such as deadlock priority and lock time-outs. For more information, see Options (Database Tools/T-SQL Editor/Query Execution/Advanced).

   • The ANSI node. This node contains settings that collectively specify SQL-92 standard query execution behavior. For more information, see Options (Database Tools/T-SQL Editor/Query Execution/ANSI).

   The Query Results node contains three sub-nodes:

   • The General node. For more information, see Options (Database Tools/T-SQL Editor/Query Results/General Page).

   • The Results to Grid node. For more information, see Options (Database Tools/T-SQL Editor/Query Results/Results to Grid).

   • The Results to Text node. For more information, see Options (Database Tools/T-SQL Editor/Query Results/Results to Text).

See Also

Tasks

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

Concepts

Query Results Overview