Options (Query Execution/SQL Server/General Page)
Use this page to specify the options for running SQL Server queries. Changes to these options are only applied to new SQL Server queries. To change the options for a current query, click Query Options on the Query menu, or in a SQL Server Query window right-click and select Query Options.
- SET ROWCOUNT
The default value of 0 indicates that SQL Server will wait for results until all results are received. Provide a value greater than 0 if you want SQL Server to halt the query after obtaining the specified number of rows. To turn this option off (so that all rows are returned), specify SET ROWCOUNT 0.
- SET TEXTSIZE
The default value of 2,147,483,647 bytes indicates that SQL Server will provide complete data fields up to the limit of text and ntext data fields. Provide a smaller number to limit results in the case of large values. Columns greater than the number provided will be truncated.
- Execution time-out
Sets the default value in the New Connection dialog box. Use this spin box to tell SQL Server the number of seconds to wait before canceling the query. A value of 0 indicates an infinite wait, or no time-out. This value is 0 on a new installation.
- Batch separator
Type a word that you use to separate Transact-SQL statements into batches. The default is GO.
- By default, open new queries in SQLCMD Mode
Select this check box to open new queries in SQLCMD mode. For more information about SQLCMD mode, see Edit SQLCMD Scripts with Query Editor.
When you select this option, be aware of the following limitations:
IntelliSense in the Database Engine Query Editor is turned off.
Because Query Editor does not run from the command line, you cannot pass in command-line parameters such as variables.
Because Query Editor cannot respond to operating-system prompts, you must be careful not to run interactive statements.
- Reset to Default
Click to reset all values on this page to the original default values.