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.
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.
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.
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.
Type a word that you use to separate Transact-SQL statements into batches. The default is GO.